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.
pgsql-novice by date
|Next:||From: Terry Lee Tucker||Date: 2005-09-30 10:53:25|
|Subject: Re: How to get tabloid|
|Previous:||From: Greg Sabino Mullane||Date: 2005-09-30 00:34:45|
|Subject: Re: perl DBI::Pg metacharacter \i com_list.sql|