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