Skip site navigation (1) Skip section navigation (2)

Re: Table Meta-Data

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 (view raw or flat)
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


In response to

pgsql-novice by date

Next:From: Neil BibbinsDate: 2007-01-25 16:53:41
Subject: Windows 2K Installation difficulties...
Previous:From: Brandon AikenDate: 2007-01-25 15:03:36
Subject: Re: Table Meta-Data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group