Check out pg_dump: basically, this works --
pg_dump -t tablename olddbname > table.out
followed by
psql -d newdbname < table.out
or
psql -d newdbname -f table.out
On Tue, 20 Feb 2001, Robert Kernell wrote:
> Hi. I am trying to copy tables. I want to copy a table in one database to a
> table in another database. The tables are identical. Here is to code and the
> error when using DBI. Can I just use postgresQL somehow?
>
> Thank you.
>
> Bob Kernell
> Research Scientist
> Analytical Services & Materials, Inc.
> NASA Atmospheric Sciences Competency
> Radiation and Aerolsols Branch
> email: r.w.kernell@larc.nasa.gov
> tel: 757-827-4631
>
--
James Eric Lawson
Research Publications Editor III
National Simulation Resource
eric@bioeng.washington.edu
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Everyday language is a part of the human organism and is no less
complicated than it. - Ludwig Wittgenstein (1889-1951) [Tractatus
Logico-Philosophicus, 1921]