Re: column name order matters in insert into foo from bar

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: column name order matters in insert into foo from bar
Date: 2008-12-04 13:27:04
Message-ID: 162867790812040527n5aa3bb28jbb9acc370ed33f3c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2008/12/4 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2008-12-04 13:37:51 Re: column name order matters in insert into foo from bar
Previous Message Grzegorz Jaśkiewicz 2008-12-04 13:18:07 Re: column name order matters in insert into foo from bar