am Sat, dem 27.01.2007, um 17:57:06 -0800 mailte Timasmith folgendes: > Hi, > > What query can I run to get the comments for my table columns. > > i.e. the ones on my 8.1 database added with this command: > > COMMENT ON COLUMN addresses.address_id IS 'Unique identifier for the > addresses table';
Start psql with Option -E and type '\d+ <tablename>'. (without the ') Then you can see the underlaying SQL-Query to request this. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
