[ADMIN] how do i query the type of an object?

2010-08-11 Thread Mark Rostron
Is there some way to query the data-type of ''?

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

2010-08-11 Thread Tom Lane
Mark Rostron writes: > Is there some way to query the data-type of ''? 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 -- Sent via pgsql-admin mailing list

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

2010-08-12 Thread Yeb Havinga
Tom Lane wrote: Mark Rostron writes: Is there some way to query the data-type of ''? 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. I failed finding IS OF in the pg documentation, howev