[GENERAL] insert into test_b (select * from test_a) with different column order

est_b always are the same and that the datatype of the named columns are the same. Is there a general solution I can use to do the insert? Regards, Ole Tange -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] insert into test_b (select * from test_a) with different column order

On Mon, Mar 29, 2010 at 5:09 PM, Leif Biberg Kristensen wrote: > On Monday 29. March 2010 16.51.35 Ole Tange wrote: >> I would like to do this: >> >>   insert into test_b (select * from test_a); > > Per the SQL standard, there's no inherent order between columns.