Copy Comand question - Mailing list pgsql-novice

From Sharon Cowling
Subject Copy Comand question
Date
Msg-id 200205252338.g4PNcnN05881@lambton.sslnz.com
Whole thread Raw
Responses Re: Copy Comand question  (Ron Johnson <ron.l.johnson@cox.net>)
List 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 by date:

Previous
From: "Joshua b. Jore"
Date:
Subject: Re: Why sequential scan when there's a supporting index?
Next
From: Ron Johnson
Date:
Subject: Re: Copy Comand question