Re: How to get tabloid

On Fri, Sep 30, 2005 at 06:53:25AM -0400, Terry Lee Tucker wrote:
> To answer at least part of my own question:
>
> SELECT oid FROM pg_class WHERE relname = 'cust';
>
> apparently gives the tableoid.

This query should restrict its results with pg_table_is_visible() --
otherwise you might get the wrong oid if the temporary table has
the same name as a non-temporary table, or if multiple sessions
have temporary tables with the same name.

Here's another way:

SELECT 'cust'::regclass::oid;

--
Michael Fuhr