On Thu, May 20, 2010 at 10:59 PM, Kevin Kempter
<kevink(at)consistentstate(dot)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