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

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.