On Tue, 6 May 2003, Popeanga Marian wrote:
> Hello all,
>
>
> Witch is the system view from where i can get columns for all
> tables and views ?
> Just like when pgsql> \d view
refine (get rid of cmax/cmin.....) something like:
SELECT relname,attname from pg_attribute,pg_class where attrelid =
pg_class.oid order by relname,attname;
>
>
--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr