Thread: hi

You can start with the information_schema tables, most databases have
them so it's probably best to learn them first. After that you can
delve into the pg_* tables, if you need something not in the
information_schema tables. Here's a link to some info.

http://www.alberton.info/postgresql_meta_info.html


On 05/05/2009, at 6:52 AM, pal kar wrote:

> Hi everyone !
>
> I am supposed to get the properties of
> each column of each table in a database
> of postgresql.
>
> I know querying the tables of a database
> for values inside them. But not how to
> get the information about the tables themselves.
> This is new for me.
>
> Can someone extend their help please ?
>
>
> Pal

Replying to message from pal kar <palkar0504@gmail.com>:

> Hi everyone !
> I am supposed to get the properties of
> each column of each table in a database
> of postgresql.
>
> I know querying the tables of a database
> for values inside them. But not how to
> get the information about the tables themselves.
> This is new for me.
>
> Can someone extend their help please ?
>
>
> Pal

If you are using psql, try "\d tablename"

--
Cliff