blob: 2c7d17ddb8876de4431defad8693287e34757db4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
version 1.13.dhb.2 README
---------------------------
* Fixed dumpTable output to output lengths for char and varchar types!
* Added single. quote to twin single quote expansion for 'insert' string
mode.
version 1.13.dhb README
-------------------------
This is a modified version of the pg_dump.c program that is distributed with
pg95 1.01. Modifications include:
* Applied 'insert string' patch from "Marc G. Fournier" <scrappy@ki.net>
(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
Comments:
-----------------------------------------------------
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
|
