Re: COPY is not working

On Fri, Apr 30, 2010 at 1:13 AM, Takahiro Itagaki
<itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:
>
> Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)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