Hi,
I have to create a script which imports csv data into postgresql ...and have a
few questions about the best way to do it.
The csv data is automatically created from an external database so I have no
influence over which columns etc are downloaded.
The csv comes without an fid field and
On 28/06/2012 12:53, Robert Buckley wrote:
Hi,
I have to create a script which imports csv data into postgresql ...and
have a few questions about the best way to do it.
The csv data is automatically created from an external database so I
have no influence over which columns etc are
From: pgsql-general-ow...@postgresql.org On Behalf Of Robert Buckley
Sent: Donnerstag, 28. Juni 2012 13:53
To: pgsql-general@postgresql.org
Subject: [GENERAL] create a script which imports csv data
Hi,
I have to create a script which imports csv data into postgresql
...and have
Robert Buckley wrote:
I have to create a script which imports csv data into postgresql
The csv data is automatically created from an external database
so I have no influence over which columns etc are downloaded.
How can I best create a table for the import?
This is what I do:
1) I have a
On Thu, Jun 28, 2012 at 2:12 PM, Berend Tober bto...@broadstripe.net wrote:
Robert Buckley wrote:
I have to create a script which imports csv data into postgresql
The csv data is automatically created from an external database
so I have no influence over which columns etc are downloaded.
On 06/28/2012 07:53 PM, Robert Buckley wrote:
Hi,
I have to create a script which imports csv data into postgresql
...and have a few questions about the best way to do it.
The advice already given is pretty good. Remember you can always create
a clean new table then INSERT INTO ... SELECT