Postgres Pro
Downloads
Home   >   mailing lists

column names from temporary tables - Mailing list pgsql-general

From Kabai József
Subject column names from temporary tables
Date
Msg-id 02d501c28731$78c77500$6b01a8c0@audiobox.hu
Whole thread Raw
In response to Re: Restoring a db dump with tsearch fields fails  ("Robert John Shepherd" <robert@reviewer.co.uk>)
Responses Re: column names from temporary tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hi All,
I know how to get column names from tables:

select attname from pg_attribute where attrelid=(select oid from
pg_class where relname='table1');

but it does not work for temporary tables, because when creating it gets a system name like 'pg_temp_6410_1'

Is there any solution for it?
Thanks, Joseph

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: PostgreSQL v7.3b5 Packaged for Testing ...
Next
From: Andrei Ivanov
Date:
Subject: Re: PostgreSQL v7.3b5 Packaged for Testing ...