Copy Comand question

From: Sharon Cowling <sharon(dot)cowling(at)sslnz(dot)com>
To: "Pgsql-Novice (E-mail)" <pgsql-novice(at)postgresql(dot)org>
Subject: Copy Comand question
Date: 2002-05-25 23:38:00
Message-ID: 200205252338.g4PNcnN05881@lambton.sslnz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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.

Here is the command:

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

Regards,

Sharon Cowling

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ron Johnson 2002-05-26 03:22:05 Re: Copy Comand question
Previous Message Joshua b. Jore 2002-05-25 20:36:10 Re: Why sequential scan when there's a supporting index?