On 4/06/2010 7:26 AM, Wang, Mary Y wrote:
I thought about DROP DATABASE, but wasn't sure if it would clean up EVERYTHING.
It won't remove your users and roles, or anything else that you see
reported in pg_dumpall --globals-only .
I assume most of you would just do the DROP DATABASE for the
, Mary Y
Subject: Re: [GENERAL] How to remove the current database and populate the
database with new data?
On Thursday 03 June 2010 4:05:14 pm Wang, Mary Y wrote:
> Hi,
>
> I've some test data in a database and would like to delete that
> database and clean everything that is associated
On Thursday 03 June 2010 4:05:14 pm Wang, Mary Y wrote:
> Hi,
>
> I've some test data in a database and would like to delete that database
> and clean everything that is associated with that database. Then I'd like
> to populate the same database with different data. My plan is to:
> (1) Remove th
On Thu, 2010-06-03 at 16:05 -0700, Wang, Mary Y wrote:
> Hi,
>
> I've some test data in a database and would like to delete that database and
> clean everything that is associated with that database. Then I'd like to
> populate the same database with different data.
> My plan is to:
> (1) Remov
Hi,
I've some test data in a database and would like to delete that database and
clean everything that is associated with that database. Then I'd like to
populate the same database with different data.
My plan is to:
(1) Remove the /usr/local/pgsql/data directory
(2) psql -e mydatabase -f /tmp/