Skip site navigation (1) Skip section navigation (2)

Re: Copy Comand question

From: John Taylor <postgres(at)jtresponse(dot)co(dot)uk>
To: "Pgsql-Novice (E-mail)" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Copy Comand question
Date: 2002-05-27 07:12:43
Message-ID: 02052708124301.01493@splash.hq.jtresponse.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Rasmus MohrDate: 2002-05-27 07:36:37
Subject: Re: Copy Comand question
Previous:From: Joel BurtonDate: 2002-05-27 06:21:54
Subject: Re: Possible use of a subselect?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group