Re: empty a database

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: empty a database
Date: 2005-02-15 19:03:36
Message-ID: 42124788.8080500@ca.afilias.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

If there are any foreign key constraints, you'll have to truncate the
tables in the appropriate order. You would also have to reset the
sequence values as well.

Naomi Walker wrote:

>How about just truncating all the tables?
>
>
>Dick Davies wrote:
>
>
>>* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [0232 16:32]:
>>
>>
>>
>>>Dick Davies <rasputnik(at)hellooperator(dot)net> writes:
>>>
>>>
>>>
>>>>Is there a neat way to clean out a database via SQL commands?
>>>>i.e. get rid of tables, sequences, integers, etc.
>>>>
>>>>
>>>>At present I'm using dropdb/createdb, but thats' far from ideal
>>>>and I think it's causing postgres to do more mork than it needs to...
>>>>
>>>>
>>>Well, if you put everything into one or a few schemas then dropping
>>>and recreating those schemas would do it. I suspect though that this
>>>is *not* faster than dropdb/createdb.
>>>
>>>
>>Thanks Tom.
>>
>>It's not just the speed, it's the constant deletes and creations in
>>~pgsql/data - as I said the other day, this is recreating a test db from the
>>production one as part of unit tests, so this happens dozens of times a day...
>>
>>
>>
>>
>
>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Joel Fradkin 2005-02-15 20:12:03 who is best for support?
Previous Message Christopher Browne 2005-02-15 18:56:44 Re: empty a database