/[hr-web]/sql/Makefile
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /sql/Makefile

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by dpavlin, Sat Apr 21 10:59:31 2001 UTC revision 1.3 by dpavlin, Sat Apr 21 14:14:42 2001 UTC
# Line 23  fill2: Line 23  fill2:
23          createdb $(db)2          createdb $(db)2
24          cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | psql $(db)2          cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | psql $(db)2
25    
26    convert: dump
27            cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | 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' > $(db)-7.sql
28    
29    
30  dist2portal:  dist2portal:
31          psql -h $(portal) -c "drop database $(db)" template1          psql -h $(portal) -c "drop database $(db)" template1
32          psql -h $(portal) -c "create database $(db)" template1          psql -h $(portal) -c "create database $(db)" template1
33          pg_dump $(db) | sed 's/::text//' | sed 's/::bool//' | 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 -h $(portal) $(db)          pg_dump $(db) | sed 's/::text//' | sed 's/::bool//' | 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' | ssh portal "psql $(db)"
34    
35  dist2test:  dist2test:
36          psql -c "drop database $(db)" template1          psql -c "drop database $(db)" template1
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.26