On Thu, May 20, 2010 at 10:59 PM, Kevin Kempter <kev...@consistentstate.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
