Обсуждение: Table Meta-Data
Hello, I am running Postgres 8.0 on a Gento Box and would like to access the information about the tables in my database. How do I access the column names, data types, comments, etc? Thanks, --greg -- Greg Lindstrom 501 975.4859 (office) Programmer 501 219-4455 (fax) NovaSys Health greg.lindstrom@novasyshealth.com Little Rock, Arkansas "We are the music makers, and we are the dreamers of dreams." W.W.
am Thu, dem 25.01.2007, um 7:38:35 -0600 mailte Greg Lindstrom folgendes: > Hello, > > I am running Postgres 8.0 on a Gento Box and would like to access the > information about the tables in my database. How do I access the column > names, data types, comments, etc? Inside psql you can use \d table and some other commands, listed with \?. If you start psql with -E, you can see the underlaying SQL-commnds to retrieve this informations. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
The information is also available through system views and system catalogs: http://www.postgresql.org/docs/8.2/interactive/catalogs.html -- Brandon Aiken CS/IT Systems Engineer -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of A. Kretschmer Sent: Thursday, January 25, 2007 9:58 AM To: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Table Meta-Data am Thu, dem 25.01.2007, um 7:38:35 -0600 mailte Greg Lindstrom folgendes: > Hello, > > I am running Postgres 8.0 on a Gento Box and would like to access the > information about the tables in my database. How do I access the column > names, data types, comments, etc? Inside psql you can use \d table and some other commands, listed with \?. If you start psql with -E, you can see the underlaying SQL-commnds to retrieve this informations. 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 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 -------------------------------------------------------------------- ** LEGAL DISCLAIMER ** Statements made in this email may or may not reflect the views and opinions of Wineman Technology, Inc. This E-mail message and any attachments may contain legally privileged, confidential or proprietary information. If you arenot the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s),you are hereby notified that any dissemination, distribution or copying of this E-mail message is strictly prohibited.If you have received this message in error, please immediately notify the sender and delete this E-mail messagefrom your computer. QS Disclaimer Demo. Copyright (C) Pa-software. Visit www.pa-software.com for more information.
If you go into psql and type \?, it will give you a list of command which do that sort of thing. Postgres 8.0 also has an INFORMATION_SCHEMA, but I don't know much about it. -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Greg Lindstrom Sent: 25 January 2007 13:39 To: pgsql-novice@postgresql.org Subject: [NOVICE] Table Meta-Data Hello, I am running Postgres 8.0 on a Gento Box and would like to access the information about the tables in my database. How do I access the column names, data types, comments, etc? Thanks, --greg -- Greg Lindstrom 501 975.4859 (office) Programmer 501 219-4455 (fax) NovaSys Health greg.lindstrom@novasyshealth.com Little Rock, Arkansas "We are the music makers, and we are the dreamers of dreams." W.W. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly