>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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of ray Sent: 2010 November 12 5:59 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
