copy- what's my root directory? - Mailing list pgsql-novice

From Eric Hulburd
Subject copy- what's my root directory?
Date
Msg-id CAFNz45sMGXh410nQaGQ08H8Gk53XxWLPfPExw_GOuu2wo+T8Lw@mail.gmail.com
Whole thread Raw
Responses Re: copy- what's my root directory?  (Carlo Ascani <carlo.ascani@2ndquadrant.it>)
List 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

pgsql-novice by date:

Previous
From: János Löbb
Date:
Subject: platform AIX ?
Next
From: Gary Chambers
Date:
Subject: C Set Returning Function (SRF)