Query 1

[trutta1]

I need to write a query that will list table name and the number of columns in each table.

example of results:

table_name + # of COLs
table_one | 20
table_two | 350

.
.
.

 

[mirtheil]

What version of PSQL are you using?
This one works with PSQL v9.5:
select xf$name, count(xe$name) from x$field, x$file where xe$file = xf$id group by xf$name

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[trutta1]

now how do I add the number of bytes in a record and the number of rows in the table to the query

 

[mirtheil]

That data is not directly available. The bytes in the record could be counted by using the sum of the XE$SIZE field for each of the tables. THe record count is not going to be available without issuing a "SELECT COUNT(*) FROM table" query.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com