On May 29, 11:35 pm, Erwin Brandstetter <[EMAIL PROTECTED]> wrote:
> EXECUTE
> 'SELECT '
> || (SELECT array_to_string(ARRAY(
> SELECT a.attname
> FROM pg_class c, pg_namespace nc, pg_attribute a
> WHERE c.relname = 'v_event'
> AND c.relnamespace = nc.oid
> AND nc.nspname = 'stdat'
> AND a.attrelid = c.oid
> AND a.attname <> 'log_up'), ', '))
> || ' FROM stdat.v_event';
You might want to add:
AND a.attnum >=1
to remove "tableoid" and friends from the output.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
