ANNOUNCE: pg_dumplo 0.0.5

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: pgsql-sql <pgsql-sql(at)postgreSQL(dot)org>
Subject: ANNOUNCE: pg_dumplo 0.0.5
Date: 2000-06-15 16:37:04
Message-ID: Pine.LNX.3.96.1000615183300.1884E-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message The Hermit Hacker 2000-06-15 17:20:13 Re: ANNOUNCE: pg_dumplo 0.0.5
Previous Message Alex 2000-06-15 06:55:15 Re: Simple search question