Re: Copy Comand question

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(at)netpointers(dot)com
Denmark Website : http://www.netpointers.com

"Remember that there are no bugs, only undocumented features."
--------------------------------------------------------------

> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>