Re: Disabling WAL for bulk data loads

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Disabling WAL for bulk data loads
Date: 2005-09-11 14:17:20
Message-ID: d7bd38b0cc1a9948046a5d504ea3d22f@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Jim C. Nasby asked:
> Can't it export CSV? Copy can deal with CSV.

Nope. I was not exaggerating the difficulty of their utilities earlier.
Oracle's export program writes to a binary format that is readable
only by Oracle's import program. And don't get me started on "sqlplus",
their command-line equivalent to psql. Quite possibly the worst
command-line database interface ever. :)

On the plus side, there are third-party tools that can do a CSV or other
type of dump from an Oracle database.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200509111014
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFDJDxRvJuQZxSWSsgRAsbPAJ96Y3mKIa8NEaEMJyMxSuTgyfNRQgCgjD0v
H9qeHqpDibCXPUEhTx0W3W0=
=7FCI
-----END PGP SIGNATURE-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Pradeepkumar, Pyatalo (IE10) 2005-09-12 03:00:23 Re: Please help - libpq API
Previous Message Mauri Sahlberg 2005-09-11 06:40:54 Re: Stupid question about triggers