| From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | Popeanga Marian <pmarian(at)cnlo(dot)ro> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: pg_ ? |
| Date: | 2003-05-06 17:48:04 |
| Message-ID: | Pine.LNX.4.44.0305061547220.22644-100000@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2003-05-06 17:53:22 | Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 |
| Previous Message | Diehl, Jeffrey | 2003-05-06 17:45:00 | Re: pgsql Replication Proxy (was Re: Replication for a |