Re: COPY IN as SELECT target

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: COPY IN as SELECT target
Дата
Msg-id 5461.1261075855@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: COPY IN as SELECT target  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: COPY IN as SELECT target  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> You might want to specify column names as well as well as types, in
> this second case.

Well, we could do it like VALUES: arbitrarily name the columns column1
... columnN and tell people to use an alias if they want other names.
If it's convenient to fit column names into the syntax, good, but we
don't absolutely have to.

[ thinks... ] Although actually the obvious SQL-ish syntax for a rowtype
specification is
( colname typename [ , ... ] )

so that's probably what we'd want to do in the processed-data case.
Not sure about the raw-data case --- maybe a predetermined name is
okay there.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: determine snapshot after obtaining locks for first statement
Следующее
От: Tom Lane
Дата:
Сообщение: Re: determine snapshot after obtaining locks for first statement