Thread: Copy Comand question

Copy Comand question

From
Sharon Cowling
Date:
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




Re: Copy Comand question

From
Ron Johnson
Date:
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
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. 

It's not possible. COPY is meant to dump raw data from a table.

--
+---------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net     |
| Jefferson, LA  USA      http://ronandheather.dhs.org:81 |
|                                                         |
| "I have created a government of whirled peas..."        |
|   Maharishi Mahesh Yogi, 12-May-2002,                   |
!   CNN, Larry King Live                                  |
+---------------------------------------------------------+


Re: Copy Comand question

From
John Taylor
Date:
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
itusing MS Excel.  It works fine apart from not having any headings, which the users need as there can be a lot of data
inthe .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

Re: Copy Comand question

From
Rasmus Mohr
Date:
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
>
>

Re: Copy Comand question

From
Sharon Cowling
Date:
Hi,

I didn't think that copy did it, I'm adding the headings via a shell script.
Thanks for your suggestion.

Regards,

Sharon Cowling




Quoting John Taylor <postgres@jtresponse.co.uk>:

> 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
>


-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/