type aliases in 7.0.3

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

Browse pgsql-sql by date

  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 ...