Skip site navigation (1) Skip section navigation (2)

Re: Help in Getting Started

From: "Elford,Andrew [Ontario]" <Andrew(dot)Elford(at)ec(dot)gc(dot)ca>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help in Getting Started
Date: 2010-11-12 14:45:21
Message-ID: 33F9E32CDB0917428758DD583E747CC80DC11B01@OntExch3.ontario.int.ec.gc.ca (view raw or flat)
Thread:
Lists: pgsql-general
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of ray
Sent: 2010 November 12 5:59 AM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org) To
make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In response to

pgsql-general by date

Next:From: Paul TaylorDate: 2010-11-12 15:27:41
Subject: Can you check in SQL if a fields can be encoded using specified charset
Previous:From: Allan KamauDate: 2010-11-12 11:48:15
Subject: Re: Considering Solid State Drives

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group