From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How to get tabloid |
Date: | 2005-09-30 10:53:25 |
Message-ID: | 200509300653.25463.terry@esc1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
To answer at least part of my own question:
SELECT oid FROM pg_class WHERE relname = 'cust';
apparently gives the tableoid.
On Friday 30 September 2005 06:25 am, Terry Lee Tucker saith:
> List,
>
> I have a temporary table and I need to get the tableoid from the interface.
> The table may not have any data in it so something like SELECT tableoid
> FROM tmp_table LIMIT 1, returns zero when there is no data in the table. I
> know that you can get information like this from the system catalogs but
> don't know how to join them to accomplish this. Is there a diagram
> available which shows the system catalog relationships and does anyone have
> a simple sql string that will give me the tableoid of a given table.
>
> TIA
>
> --
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
--
From | Date | Subject | |
---|---|---|---|
Next Message | A Gilmore | 2005-09-30 17:01:56 | Interval fields |
Previous Message | Terry Lee Tucker | 2005-09-30 10:25:05 | How to get tabloid |