On 6/11/07, Mike Gould <mgould@xxxxxxxxxxxx> 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.
