Differences

This shows you the differences between two versions of the page.

--- notes:postgres [2015/08/11 13:55]
jiggak
+++ notes:postgres [2015/08/11 14:19]
jiggak
@@ Line 5: / Line 5: @@
 </code>
+<code>
+-- run bcp in windows cmd to dump table
+bcp Campaign out campaign.data -c -k -S (localdb)\Projects -T -d EDC
+-- convert line endings to unix
+dos2unix campaign.data
+-- import data with psql
+copy campaign from '/media/sf_D_DRIVE/pg_migrate/campaign.data' with null as '';
+</code>

Slashdev Wiki