From the shell, I use something like this :
psql -d datebasename -U username -c "COPY tablename FROM 'datefile' WITH
DELIMITER ',' NULL '' ;"
You'll have to add the path to the psql binary and to the csv file
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of ray
Sent: 2010 November 12 5:59 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Help in Getting Started
I just downloaded 9.0 onto my laptop and desktop Windows XP machines.
I would like to move data from an Excel spreadsheet into a database.
I understand that a method is to export the worksheet as a CVS and then
'copy' into the database.
I have not been able to get function to happen in the shell.I have tried
creating a database in the shell but failed. I was able to
create one in pgAdmin III. I have read a copy tutorials but have not
been able to find one that is a simple step by step.
I would appreciate any help in learning how to learn.
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To
make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
