Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?

Поиск
Список
Период
Сортировка
От Eric Ridge
Тема Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Дата
Msg-id CANcm6waaPok=wooh4L+d3KxkWJBj1JK-Bac5K72k=hpL-AgXAg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On Tue, Nov 1, 2011 at 1:33 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> COPY (SELECT * EXCLUDING (a, b, c) FROM <big query>) TO 'somefile.csv' WITH CSV;
>>
> sorry, I don't accept it. I am able to understand your request for
> adhoc queries. But not for COPY.

I apologize if that example was confusing.  I wasn't also suggesting
expanding COPY's syntax.  I was merely pointing out that if
"EXCLUDING(…)" were implemented, you'd be able to use it within the
query given to the COPY command.

eric

ps, it seems my messages aren't hitting the list?  weird.


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: removing =>(text, text) in 9.2
Следующее
От: Tom Lane
Дата:
Сообщение: Testing for safe fetching of TOAST values