am 05.11.2005, um 16:47:56 +0000 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 to see both the hidden SQL and the description. Example: comment on table foo is 'this is a comment'; \dd foo [many lines of output the SQL and the comment] Use '\h?' to see all psql-commands. HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
