| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | "Pgsql-Novice (E-mail)" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Copy Comand question |
| Date: | 2002-05-26 03:22:05 |
| Message-ID: | 1022383325.8556.47.camel@rebel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sat, 2002-05-25 at 18:38, Sharon Cowling wrote:
> 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 using MS 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.
It's not possible. COPY is meant to dump raw data from a table.
--
+---------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://ronandheather.dhs.org:81 |
| |
| "I have created a government of whirled peas..." |
| Maharishi Mahesh Yogi, 12-May-2002, |
! CNN, Larry King Live |
+---------------------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volker Roehl | 2002-05-26 08:45:46 | german decimal / locale |
| Previous Message | Sharon Cowling | 2002-05-25 23:38:00 | Copy Comand question |