1 |
db=inncomm |
2 |
|
3 |
all: |
4 |
@echo dump,create,drop,insert,fill |
5 |
|
6 |
dump: |
7 |
pg_dump $(db) > $(db).sql |
8 |
|
9 |
dump2: |
10 |
pg_dump -s $(db) > $(db).sql.prazno |
11 |
|
12 |
create: |
13 |
createdb $(db) |
14 |
drop: |
15 |
psql -c "drop database $(db)" template1 |
16 |
|
17 |
insert: |
18 |
# psql $(db) < $(db).sql |
19 |
cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | psql $(db) |
20 |
|
21 |
fill: drop create insert |
22 |
|
23 |
fill2: |
24 |
destroydb $(db)2 |
25 |
createdb $(db)2 |
26 |
psql $(db)2 < $(db).sql |
27 |
|
28 |
fix: |
29 |
pg_dump $(db) > $(db).sql |
30 |
destroydb $(db) |
31 |
# cat $(db).sql | sed 's/"unesen" timestamp/"unesen" timestamp default now()/' > $(db).sql.new |
32 |
cat $(db).sql | sed 's/character varying(30),/character varying(250),/' > $(db).sql.new |
33 |
createdb $(db) |
34 |
psql $(db) < polar.sql |
35 |
|