Re: [GENERAL] Emptying a database. - Mailing list pgsql-general

From Jeremiah Davis
Subject Re: [GENERAL] Emptying a database.
Date
Msg-id Pine.3.89.9810081129.A6125-0100000@onramp.freeway.net
Whole thread Raw
In response to [GENERAL] Emptying a database.  (Stuart Rison <stuart@ludwig.ucl.ac.uk>)
List pgsql-general
you just want to dump all the data?  just use delete then..

DELETE FROM tablename;

Deletes all the data in the table....



On Thu, 8 Oct 1998, Stuart Rison wrote:

> 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@ludwig.ucl.ac.uk              |
> +-------------------------+--------------------------------------+
>
>
>
>

pgsql-general by date:

Previous
From: Stuart Rison
Date:
Subject: [GENERAL] Emptying a database.
Next
From: Stuart Rison
Date:
Subject: Re: [GENERAL] Emptying a database.