2010/4/30 Jaime Casanova <jcasa...@systemguards.com.ec>: > On Fri, Apr 30, 2010 at 1:13 AM, Takahiro Itagaki > <itagaki.takah...@oss.ntt.co.jp> wrote: >> >> Jaime Casanova <jcasa...@systemguards.com.ec> wrote: >> >>> ah! this is because COPY doesn't follow inherited tables... should it? >> >> Yes. You can use "COPY (SELECT * FROM a) TO " instead to copy all tuples. >> >> http://developer.postgresql.org/pgdocs/postgres/sql-copy.html >> | COPY can only be used with plain tables, not with views. >> | However, you can write COPY (SELECT * FROM viewname) TO .... >> >> Should we add "or parent tables" after "not with views"? >> To be exact, it would be "'COPY a parent table TO' only copies >> tuples in the parent table and does not copy inherited child tables". >> > > +1 on make this clear on the docs
It works with parent table. Depends if the parent table have data or not. COPY is more like SELECT FROM ONLY table, isn't it ? > > -- > Atentamente, > Jaime Casanova > Soporte y capacitación de PostgreSQL > Asesoría y desarrollo de sistemas > Guayaquil - Ecuador > Cel. +59387171157 > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Cédric Villemain -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
