| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | John Wells <jb(at)sourceillustrated(dot)com> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Recovering data via raw table and field separators |
| Date: | 2007-12-05 16:40:41 |
| Message-ID: | 20071205164041.GG16991@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John Wells wrote:
> I have pg_filedump installed, but can't figure out how to dump the
> rows themselves. I get the equivalent of the output at the end of this
> post. Looking over the --help, there's nothing obvious that has gotten
> me further.
-i is the option you need; but you have to keep in mind that it won't
show you the textual representation of data. It will only get you
internal representation (binary).
--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"MySQL is a toy compared to PostgreSQL." (Randal L. Schwartz)
(http://archives.postgresql.org/pgsql-general/2005-07/msg00517.php)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-12-05 17:05:26 | Re: Recovering data via raw table and field separators |
| Previous Message | Alvaro Herrera | 2007-12-05 16:27:59 | Re: 8.3 beta FATAL: invalid value for parameter "timezone_abbreviations": "Default" |