pg_dump, schemas and 7.4/7.3

Started by Richard Huxtonover 22 years ago1 messages
#1Richard Huxton
dev@archonet.com

I'd really like to be able to dump a single schema from 7.3 for a current
project.

Now I can write a script to run \dt and then "pg_dump -t" each table, but
that's not going to help me with sequences etc.

Of course, in 7.4 pg_dump will do exactly what I want, which seems to give me
two options:

1. Use 7.4 pg_dump to dump my 7.3 schema
2. Back-port pg_dump from 7.4 to 7.3

The questions are: will (1) work, or is (2) a viable option for someone who
hasn't coded C for 10+years?

TIA
--
Richard Huxton