Specifying Windows absolute path in Windows PostgreSQL

[WaldoNJ]

I have installed the windows version of PostgreSQL and want to do a bulk insert to a table from a CSV file on a CD-ROM. How do I specify a windows D:\filename.csv file when the copy command expects a *nix /usr/file absolute path.

 

[Leland123]

Hi WaldoNJ,

You should be able to use the copy command to move a CVS file into a table or to move a table to a CVS file.

http://www.smvfp.com/pgsqlhtml/sql-copy.html

Regards,

LelandJ

Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox