Rodrigo De León wrote:
On 3/13/07, T E Schmitz <[EMAIL PROTECTED]> wrote:
This is pretty ingenious!
Just a few minor problems:
- how does COPY know which column is which?
- how do I specify DELIMITER as TAB?
See:
http://www.postgresql.org/docs/8.2/static/sql-copy.html
Thank you for the links. I had read of the manual entry for the COPY
command and I know that I need something like
psql -h lolek -U tes -d stockmarket -c "copy history from STDIN
DELIMITER AS TAB CSV" < /tmp/FTSE.csv
My problem is how to specify the tab character on the command line
seeing as the COPY command is already enclosed in quotes.
When creating CSV output I use -F $'\t' on Unix. However,
DELIMITER AS $'\t' doesn't work.
Also, it's nopt happy about the date format : 2007/02/09
See:
http://www.postgresql.org/docs/current/static/runtime-config-client.html#GUC-DATESTYLE
--
Regards,
Tarlika Elisabeth Schmitz
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
