On 6/11/07, Mike Gould <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend