On 6/11/07, Mike Gould <mgould(at)allcoast(dot)net> wrote:
> How can we do this with PostGres? Other than backup and restore or creating
> SQL scripts I haven't been able to find another method. Some of these
> tables may have over a million rows in them initially if we convert old
> data.
The most portable way is probably pg_dump as plaintext:
pg_dump -Fp mydatabase >mydatabase.dump
Then restore with:
cat mydatabase.dump | psql mydatabase
Alexander.