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;

<code bash> – 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?