Postgres Pro
Downloads
Home   >   mailing lists

Re: how do i query the type of an object? - Mailing list pgsql-admin

From Tom Lane
Subject Re: how do i query the type of an object?
Date
Msg-id 1823.1281577198@sss.pgh.pa.us
Whole thread Raw
In response to how do i query the type of an object?  (Mark Rostron <mrostron@ql2.com>)
Responses Re: how do i query the type of an object?  (Yeb Havinga <yebhavinga@gmail.com>)
List pgsql-admin
Tree view 
Mark Rostron <mrostron@ql2.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

pgsql-admin by date:

Previous
From: Mark Rostron
Date:
Subject: how do i query the type of an object?
Next
From: "Gnanakumar"
Date:
Subject: Re: Autovacuum daemon internal handling