Postgres Pro
Downloads
Home   >   mailing lists

Re: column name order matters in insert into foo from bar - Mailing list pgsql-general

From Pavel Stehule
Subject Re: column name order matters in insert into foo from bar
Date
Msg-id 162867790812040527n5aa3bb28jbb9acc370ed33f3c@mail.gmail.com
Whole thread Raw
In response to Re: column name order matters in insert into foo from bar  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
Responses Re: column name order matters in insert into foo from bar
List pgsql-general
Tree view 
2008/12/4 Grzegorz Jaśkiewicz <gryzman@gmail.com>:
> to answer myself, and also make matter a bit more complicated.
> the table has like 20 columns, so - yes, I can probably name all of
> them one by one, but - is there any way to do it without need to name
> all of them ?
>

no,

regards
Pavel Stehule

p.s. you can try use stored procedure for generating these statements


> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: column name order matters in insert into foo from bar
Next
From: Gustavo Rosso
Date:
Subject: serial