Tuesday, 15 February 2011

PostgreSQL Include special characters in copy/import -


This is a very quick question on using the postgresql copy feature to import a csv file.

If I have a line with the data like

  random, 1689, rnd \\ 168  

I have special How do I include characters?

  random 1689 rnd \\ 168  

< What is the use of P> command?

  Copy my_table from 'full_csv_file_path' with CPV delimiter ';';  

Enter image details here

and The CSV file is containing:

  random, 1689, rnd \\ 168  

No comments:

Post a Comment