From: | Stuart Rison <stuart(at)ludwig(dot)ucl(dot)ac(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | [GENERAL] Emptying a database. |
Date: | 1998-10-08 15:01:12 |
Message-ID: | l03110721b242835641f1@[128.40.242.190] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear All,
I'm currently doing some database design work and find myself entering
loads of test records into my database tables.
Occasionally I want to 'flush' out the database (i.e. keep all tables,
views, etc. but delete all records). Currently I have to pg_dump the
database and then use a text editor to cut out all the 'copy' statements
out and recreate a 'new' database.
Is there a way of flushing the content of all tables?
Thanks for any help you may provide.
Cheers,
Stuart.
+-------------------------+--------------------------------------+
| Stuart Rison | Ludwig Institute for Cancer Research |
+-------------------------+ 91 Riding House Street |
| Tel. (0171) 878 4041 | London, W1P 8BT, UNITED KINGDOM. |
| Fax. (0171) 878 4040 | stuart(at)ludwig(dot)ucl(dot)ac(dot)uk |
+-------------------------+--------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremiah Davis | 1998-10-08 15:08:34 | Re: [GENERAL] Emptying a database. |
Previous Message | Memphisto | 1998-10-08 14:36:01 | My further experiences with ecpg |