> >> 1. COPY from a text field in a table like this COPY from (select >> text_field from table where id =2) as text_data ... > > The syntax is a bit different: > CREATE TABLE text_data AS select text_field from table where id=2 Really? Wow, I would have never guessed that. That's awesome. Thanks. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general