viewvc.cgi/fcproducts/Makefile


db=fcproducts

all:
        @echo dump,create,drop,insert,fill

dump:
        pg_dump -c $(db) > $(db).sql

create:
        createdb $(db)
drop:
        psql -c "drop database $(db)" template1

insert:
        cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | psql $(db)

fill: drop create insert

1
2	db=fcproducts
3
4	all:
5	@echo dump,create,drop,insert,fill
6
7	dump:
8	pg_dump -c $(db) > $(db).sql
9
10	create:
11	createdb $(db)
12	drop:
13	psql -c "drop database $(db)" template1
14
15	insert:
16	cat $(db).sql \| sed 's/::text//' \| sed 's/::bool//' \| psql $(db)
17
18	fill: drop create insert
19