Copy Comand question

Поиск
Список
Период
Сортировка
От Sharon Cowling
Тема Copy Comand question
Дата
Msg-id 200205252338.g4PNcnN05881@lambton.sslnz.com
обсуждение исходный текст
Ответы Re: Copy Comand question
Список pgsql-novice
Hi,

I am using the copy command to create a .csv file, how do I include the table headings, or headings of my choice?
The purpose of this paticular .csv file is to enable the users to download data from a web page and then report on it
usingMS Excel.  It works fine apart from not having any headings, which the users need as there can be a lot of data in
the.csv file. 

Here is the command:

<code snippet>
\COPY temp_table TO $OUTFILE USING DELIMITERS ',' WITH NULL AS ' ';
</code snippet>

Regards,

Sharon Cowling




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

Предыдущее
От: "Joshua b. Jore"
Дата:
Сообщение: Re: Why sequential scan when there's a supporting index?
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Copy Comand question