Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY is not working - Mailing list pgsql-hackers

From Tom Lane
Subject Re: COPY is not working
Date
Msg-id 14785.1272657003@sss.pgh.pa.us
Whole thread Raw
In response to COPY is not working  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-hackers
Tree view 
Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> COPY is not working on latest HEAD?

I've added this to the COPY notes section:
  <para>   <command>COPY</command> only deals with the specific table named;   it does not copy data to or from child
tables. Thus for example   <literal>COPY <replaceable class="parameter">table</> TO</literal>   shows the same data as
<literal>SELECT* FROM ONLY <replaceable   class="parameter">table</></literal>.  But <literal>COPY   (SELECT * FROM
<replaceableclass="parameter">table</>) TO ...</literal>   can be used to dump all of the data in an inheritance
hierarchy. </para>
 
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: pg_start_backup and pg_stop_backup Re: Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct
Next
From: Stefan Kaltenbrunner
Date:
Subject: HS - odd process listing