Re: SELECT from mytbl; - Mailing list pgsql-general

From Erwin Brandstetter
Subject Re: SELECT from mytbl;
Date
Msg-id 1180502889.101098.267550@p47g2000hsd.googlegroups.com
Whole thread Raw
In response to Re: SELECT from mytbl;  (Rodrigo De León <rdeleonp@gmail.com>)
List pgsql-general
On May 30, 6:48 am, Rodrigo De León <rdele...@gmail.com> wrote:
> On May 29, 11:35 pm, Erwin Brandstetter <brsaw...@gmail.com> 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


pgsql-general by date:

Previous
From: novnov
Date:
Subject: Re: function retuning refcursor, order by ignored?
Next
From: PFC
Date:
Subject: Re: SELECT from mytbl;