> 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
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
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