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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: column name order matters in insert into foo from bar
Дата
Msg-id 162867790812040527n5aa3bb28jbb9acc370ed33f3c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: column name order matters in insert into foo from bar  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
Ответы Re: column name order matters in insert into foo from bar
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "Grzegorz Jaśkiewicz"
Дата:
Сообщение: Re: column name order matters in insert into foo from bar
Следующее
От: Gustavo Rosso
Дата:
Сообщение: serial