Writing /var/www/html/conf/plugins.local.php failed
notes:postgres
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision Next revision Both sides next revision | ||
|
notes:postgres [2015/08/11 13:54] jiggak created |
notes:postgres [2015/08/11 14:19] jiggak |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | | + | <code sql> |
| - | create role josh with login; | + | -- basic access by nix user |
| - | create database edc owner josh; | + | 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 '/ | ||
| + | </ | ||
notes/postgres.txt · Last modified: 2015/08/17 14:05 by jiggak
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
