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: | Raw Message | Whole Thread | 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 ... |