check if type is valid pg type - Mailing list pgsql-novice

From Dominik Moritz
Subject check if type is valid pg type
Date
Msg-id 0258E307-2F55-4E9B-83C6-17B48FE0505F@gmail.com
Whole thread Raw
Responses Re: check if type is valid pg type
List pgsql-novice
Hi all,

I need to check, whether a type is a valid postgres type or not. My first take was to check in the pg_type table.
However,pg_type does not list types such as integer (but it does list int4) or float (but it does indeed list float8).
Whatis the best way to check whether a type is valid or not? 

Thanks,
Dominik
Attachment

pgsql-novice by date:

Previous
From: Tom Browder
Date:
Subject: Re: Using Different Ports for Multiple PosgreSQL Installations: Any Issues?
Next
From: "Raghavendra"
Date:
Subject: Converting from strings to c data types