Re: how do i query the type of an object?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Rostron <mrostron(at)ql2(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: how do i query the type of an object?
Date: 2010-08-12 01:39:58
Message-ID: 1823.1281577198@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mark Rostron <mrostron(at)ql2(dot)com> writes:
> Is there some way to query the data-type of '<some value expression>'?

There's a SQL-standard construct called IS OF, and a function called
pg_typeof, but it's not real clear whether either of those would help
you.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gnanakumar 2010-08-12 04:56:34 Re: Autovacuum daemon internal handling
Previous Message Mark Rostron 2010-08-12 00:37:20 how do i query the type of an object?