Kevin Kempter <[email protected]> writes:
> I have an sql stmt that runs:
> insert into x
> ( a.col1, a.col2, a.col3,b.col1,b.col2)
> select blah,blah,blah
> ...
> from giant_table a,
> even_bigger_table b
> where.....
> I wonder, could I convert this to use COPY into the table (x) instead of the
> select stmt?
Why would you want to? It's certain to be far slower.
regards, tom lane
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
