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