Thread: hi

hi

From
pal kar
Date:
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

Re: hi

From
Adam Ruth
Date:
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


Re: hi

From
Cliff Nieuwenhuis
Date:
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