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