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

copy- what's my root directory?

From: Eric Hulburd <ehulburd(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: copy- what's my root directory?
Date: 2011-09-07 21:36:51
Message-ID: CAFNz45sMGXh410nQaGQ08H8Gk53XxWLPfPExw_GOuu2wo+T8Lw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,
I've got another newbie question.  I want to copy some csv data into my
postgresql database.  I'm confused with the syntax though.  I entered

mydb=# copy mytable from '/data.csv';

It tells me it can't find data.csv, which means I saved it in the wrong
place.  I've tried the data and scripts folder.  Where do I save
import/export files and where is all my database work being saved?

Thanks.
Eric

Responses

pgsql-novice by date

Next:From: Gary ChambersDate: 2011-09-08 02:16:33
Subject: C Set Returning Function (SRF)
Previous:From: János LöbbDate: 2011-09-07 19:45:29
Subject: platform AIX ?

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