On May 30, 6:48 am, Rodrigo De León <[EMAIL PROTECTED]> wrote: > 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.
Hmmm .. I don't get "tableoid" and friends in my results as it is (without "AND a.attnum >=1") Maybe because all my tables are created "WITHOUT OIDS"? I have to test this another time .. Regards Erwin ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
