[SQL] Extract table columns in tabular form

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

Re: [SQL] Extract table columns in tabular form

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

Re: [SQL] Extract table columns in tabular form

> 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

[SQL] Insert large text to text column

Can I open an OutputStream to write data a column (type=text). If yes, what is this pattern from select to get OutputStream __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ---(end of broad