From: "David Bennett" Date: Tue, 11 Jun 1996 12:53:11 -0006 Subject: [PG95]: New version of pg_dump I have modified pg_dump to add serveral new features. I am distributing this as a new tar.gz instead of a patch because it is a second generation modification (uses scrappy@ki.net insert patch). The file can be transfered from: ftp://ftp.bensoft.com/pub/sql/pg95/pg_dump.113.dhb.tar.gz Here is a run-down on the new features... * Applied 'insert string' patch from "Marc G. Fournier" (see insert.patch & README.scrappy for info on this patch) * Added '-t table' option By specifying '-t table' on the command line you can output only the schema (table & index defs) and data for one table of a database. Example: pg_dump -t descriptions software * Added '-a' option This is the opposite of the -S option. By specifying -a you can output only the database data and not the schema. Example: pg_dump -a zipcodes * Added '-da' option Marc's '-d' option adds the ability to output insert strings, By using the 'a' sub-parameter you can also place the attribute names in the insert strings. Basically, this is useful because ALTER TABLE is broken in pg95 1.01. NOTE: This will create some long hairy output files! Be sure to pipe through compress or gzip before outputing to disk. Example: pg_dump -da -t oldfile mydatabase | gzip > oldfile.data.gz - ------------------------------------------------------- David Bennett, Bennett Software Solutions 2608 NW Fawn Drive Blue Springs, MO 64015 Phone: 816-228-8788, Fax: 816-228-3204 dave@bensoft.com, http://bensoft.com PGP key at ftp://bensoft.com/pub/pgp/daveskey.txt