How about doing the file generation using a scripting langugage (PHP, Perl,
...)?
--------------------------------------------------------------
Rasmus T. Mohr Direct : +45 36 910 122
Application Developer Mobile : +45 28 731 827
Netpointers Intl. ApS Phone : +45 70 117 117
Vestergade 18 B Fax : +45 70 115 115
1456 Copenhagen K Email : mailto:rmo@netpointers.com
Denmark Website : http://www.netpointers.com
"Remember that there are no bugs, only undocumented features."
--------------------------------------------------------------
> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of John Taylor
> Sent: Monday, May 27, 2002 9:13 AM
> To: Pgsql-Novice (E-mail)
> Subject: Re: [NOVICE] Copy Comand question
>
>
> On Sunday 26 May 2002 04:22, you wrote:
> > 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.
> >
>
>
> I know it is a bit of a bodge - but ...
> How about having a heading table.
> Then create a view which is a union to the two tables, and
> copy out the view.
>
> JohnT
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>