| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | type aliases in 7.0.3 |
| Date: | 2002-02-07 00:46:09 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOAEEMCBAA.chriskl@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi guys,
A ways back I was told about the format_type function in postgres to get
type aliases. Hence I can get a list of types like this:
SELECT typname FROM pg_type pt WHERE typname NOT LIKE '\\\_%'
AND typname NOT LIKE 'pg\\\_%'
UNION
SELECT format_type(pt.oid, NULL) FROM pg_type pt WHERE typname NOT LIKE
'\\\_%' AND typname NOT LIKE 'pg\\\_%'
EXCEPT
SELECT relname FROM pg_class ORDER BY typname;
Only problem - the format_type function only exists in 7.1 and above - how
do I do this query in 7.0.3??
This is for the phpPgAdmin project.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rudi | 2002-02-07 01:51:23 | pg_shadow / pg_user |
| Previous Message | Marc G. Fournier | 2002-02-06 21:41:17 | Re: JOIN between three *simple* tables ... |