[FIXED] Ipython-sql default folder

Issue

I want to load data from a CSV file into a Postgresql database using the ipython-sql extension.

I followed the example on this SO question but I get error:

(psycopg2.OperationalError) could not open file "./test_file.csv" for reading: No such file or directory

I suspect this is due to a default path for the extension that is different from the notebook path. I can successfully load the data if I use an absolute path, but that's ugly. Any ideas?

Solution

you should use 'The absolute path name of the input or output file' in COPY command...

Answered By - Adam Silenko