Re: pg_ ?

> >            Witch is the system view from where i can get columns for all 
> > tables and views ?
> > Just like when pgsql> \d view
> 
> pg_class is the *system table* from which you can get the columns of all
             ^^^^^^^!
 
> tables and views.

Sorry. It is details, not columns. To get columns we can use pg_attribute
system table. For example the below sql would get the column names,

select c.relname, a.attname from pg_class c, pg_attribute a, pg_namespace
n where c.oid = a.attrelid and a.attnum > 0 and c.relnamespace = n.oid and
n.nspname = 'my_schema' and c.relname = 'my_table';

=> \d pg_attribute -- for more details

regards,
bhuvaneswaran