"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> You could possibly do this with a SRF; you'd have to grab the name of
> the table and then build a dynamic query off of that. If you cast the
> oid to regclass you'll get the name of the table, though you should
> probably query pg_class and pg_namespace
On Sun, May 13, 2007 at 09:25:37PM +0200, Felix Kater wrote:
> can I use a given tableoid (instead of the tablename) to select
> columns from that table somehow?
>
> SELECT * FROM ??tableoid??
> So, I worked around that by peforming two queries: The first to retrieve
> the table's name from pg_c
Hi,
can I use a given tableoid (instead of the tablename) to select
columns from that table somehow?
SELECT * FROM ??tableoid??
My first approach was to lauch a subquery of the information_schema
like this:
SELECT * FROM (SELECT relname FROM pg_class WHERE oid=999) AS
tablename
However, it tur
