On Thu, May 20, 2010 at 10:59 PM, Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx> wrote: > Can I copy from one db (via COPY) and pipe the results to a psql/COPY stmt so > I can load the data into a table in the second db 'inline' without writing to > & reading from a flat file? That's pretty much what pg_dump -t tablename -d dbname | psql dbname does. Add a -a and it's data only: pg_dump -a -t tablename -d dbname | psql dbname -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
