longlong escribió: > 3.sometimes, i want to copy data from one database to another. i think using > COPY will simple the code. i want the content from COPY TO not store in the > file, but in the memory, and i can COPY FROM the memory(i don't kown COPY > with STDIN and STDOUT can do this or not.). I don't think this is very interesting because you can do pg_dump -t foo | psql -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general