On Jun 29, 2005, at 7:04 PM, Richard Huxton wrote:
Zlatko Matić wrote:
How could I truncate, delete all content of all tables in one step ?
Something like this?
pg_dump --schema-only mydb > mydb.schema.dump
dropdb mydb
psql -f mydb.schema.dump mydb
That's nice!
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
