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

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

Answers


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.


Need Your Help

Charts for Android

android graph charts

I am working on a project which have some charts (graphs), tick chart, candlestick chart and range chart. But the problem is, there is no library for that charts. I have got Google chart API for

yesod test - missing dependency yesod-test

haskell cabal yesod

I was setting up a yesod scaffolded site using the yesod init command, and I named my project yesodtry. I proceeded to setup a scaffolded site using this command, which was given by yesod init: