From: | "Duncan Garland" <duncan(dot)garland(at)ntlworld(dot)com> |
---|---|
To: | "Greg Lindstrom" <greg(dot)lindstrom(at)novasyshealth(dot)com> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Table Meta-Data |
Date: | 2007-01-25 15:09:57 |
Message-ID: | MBEPKEEDMKGCDODFKLPPCELKDLAA.duncan.garland@ntlworld.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Greg Lindstrom
Sent: 25 January 2007 13:39
To: pgsql-novice(at)postgresql(dot)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(dot)lindstrom(at)novasyshealth(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Bibbins | 2007-01-25 16:53:41 | Windows 2K Installation difficulties... |
Previous Message | Brandon Aiken | 2007-01-25 15:03:36 | Re: Table Meta-Data |