Slashdev Wiki

This is an old revision of the document!

---

-- basic access by nix user
CREATE ROLE josh WITH login;
CREATE DATABASE edc owner josh;

-- 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 '';