The PostgreSQL pg_dumplo 0.0.5; in brief:
--- available at:
* ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.5.tar.gz
* or will available in the PostgreSQL contrib tree in the CVS
--- features:
pg_dumplo [option]
-h --help this help
-u --user=<username> username for connection to server
-p --password=<password> password for connection to server
-d --db=<database> database name
-t --host=<hostname> server hostname
-s --space=<dir> directory with dump tree (for export/import)
-i --import import large obj dump tree to DB
-e --export export (dump) large obj to dump tree
-l <table.attr ...> dump attribute (columns) with LO to dump tree
-a --all dump all LO in DB (default)
-r --remove if is set '-i' try remove old LO
-q --quiet run quietly
-w --show not dump, but show all LO in DB
Example (dump): pg_dumplo -d my_db -s /my_dump/dir -l t1.a t1.b t2.a
pg_dumplo -a -d my_db -s /my_dump/dir
Example (import): pg_dumplo -i -d my_db -s /my_dump/dir
Example (show): pg_dumplo -w -d my_db
Note: * option '-l' must be last option!
* option '-i' without option '-r' make new large obj in DB
not rewrite old, the '-i' UPDATE oid numbers in table.attr only!
* if is not set option -s, the pg_dumplo use $PWD
Karel
