check if type is valid pg type

From: Dominik Moritz <domoritz(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: check if type is valid pg type
Date: 2012-10-01 22:47:05
Message-ID: 0258E307-2F55-4E9B-83C6-17B48FE0505F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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). What is the best way to check whether a type is valid or not?

Thanks,
Dominik

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Raghavendra 2012-10-02 12:02:19 Converting from strings to c data types
Previous Message Tom Browder 2012-10-01 20:00:53 Re: Using Different Ports for Multiple PosgreSQL Installations: Any Issues?