Re: Table Meta-Data

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