Parent Directory | Revision Log
Initial revision
1 | dpavlin | 18 | db=nn |
2 | |||
3 | all: | ||
4 | @echo dump,create,drop,insert,fill | ||
5 | |||
6 | dump: | ||
7 | pg_dump $(db) > $(db).sql | ||
8 | |||
9 | create: | ||
10 | createdb $(db) | ||
11 | drop: | ||
12 | psql -c "drop database $(db)" template1 | ||
13 | |||
14 | insert: | ||
15 | cat $(db).sql |\ | ||
16 | sed -e 's/::"*text"*//gi' -e 's/::"*bool"*//gi' -e 's/::"*varchar"*//gi' -e 's/::"*bpchar"*//gi' |\ | ||
17 | sed 's/ \([01][0-9]\)-\([0123][0-9]\)-\([12][0-9][0-9][0-9]\) / \2-\1-\3 /g' | sed 's,/usr/lib/pgsql/,/usr/lib/postgresql/lib/,g' | psql $(db) | ||
18 | |||
19 | fill: drop create insert | ||
20 |
Name | Value |
---|---|
cvs2svn:cvs-rev | 1.1 |
svn:mime-type | application/octet-stream |
ViewVC Help | |
Powered by ViewVC 1.1.26 |