Rails App- postgresql - learning to use copy command - location of db on mac OSX?

Question

Hi Im learning how to use postgresql's COPY command to import data in from a csv file on my local drive onto the postgresql db of my rails app.

The first step is how do I find the location of postgresql on my local drive?

Wouldn't I need it to call the COPY command?

I have pg3admin which I can see as a gui, it has all my databases. but where would I be calling the copy command from?

thanks

kgrittn · Accepted Answer · 2012-05-02 15:42:49Z

2

To COPY into a table FROM a file, the file must be accessible to the OS user running the PostgreSQL server, or (more commonly) to the OS user running your client. In the latter case, you COPY tablename FROM STDIN, and your client application feeds the file to the server. To do this in psql you use \copy.

answered May 2, 2012 at 15:42

kgrittn

19.8k4 gold badges41 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zac B · Accepted Answer · 2012-05-02 13:42:58Z

0

Most of postgres lives (assuming you're using a *nix OS) in /var/lib/pgsql. The postgres manual has more info about where files are commonly found, and what each file does.

answered May 2, 2012 at 13:42

Zac B

4,3023 gold badges39 silver badges59 bronze badges

2 Comments

user330315 Over a year ago

The location of those files is completely irrelevant when using COPY

Craig Ringer Over a year ago

@a_horse_with_no_name Not completely, no. If you give a relative path to COPY it'll look for a file within the datadir.

Collectives™ on Stack Overflow

Rails App- postgresql - learning to use copy command - location of db on mac OSX?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related