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