[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 Internet Messaging Program. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
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 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
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_attribute.attrelid = pg_class.oid" - Comments are in pg_description... There seem to be links to both pg_class and pg_attribute - Type info is in pg_type, associated to pg_attribute via "atttypid" There are attributes that you normally don't see, and "dropped" attributes still exist in pg_attribute, so things are a tad more complex than what I have said, but the above 4 tables should provide you all you need... -- select 'cbbrowne' || '@' || 'acm.org'; http://linuxdatabases.info/info/slony.html Never criticize anybody until you have walked a mile in their shoes, because by that time you will be a mile away and have their shoes. -- email sig, Brian Servis ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[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 broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
