Re: [SQL] Extract table columns in tabular form

2005-11-05 Thread Christopher Browne
> How do you extract postgresql column names, types and comments in tabular > form, > using an SQL command?. I know they are stored in one of the system tables, but > I don't know which. - Table names are in pg_class - Column names are in pg_attribute, associated to pg_class via "where pg_att

Re: [SQL] Extract table columns in tabular form

2005-11-05 Thread A. Kretschmer
am 05.11.2005, um 16:47:56 + mailte frank church folgendes: > > How do you extract postgresql column names, types and comments in tabular > form, > using an SQL command?. I know they are stored in one of the system tables, but > I don't know which. Start psql with -E and call \d* - commands

[SQL] Extract table columns in tabular form

2005-11-05 Thread frank church
How do you extract postgresql column names, types and comments in tabular form, using an SQL command?. I know they are stored in one of the system tables, but I don't know which. R Church This message was sent using IMP, the Inter