In response to blackwater dev : > I have a table with a lot of columns. One of the columns I want to alias so > have a query of: > > select *, column as newname from mytable. > > The problem is I now have column and newname in the results. I don't want to > select column by column. How can I do a select * but omit one?
You can't. The only way: ask information_schema.columns and build a string that contains all except the special column and execute that string. (within a function, plpgsql). Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
