Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx> 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 (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
