From: xiong w. <wan...@gm...> - 2010-11-26 07:05:23
|
Dears, If I drop a database, it seems that content of database isn't really deleted. The steps as follows: 1.postgres=# drop database dbt1; DROP DATABASE 2.postgres=# create database dbt1; CREATE DATABASE 3.postgres=# \c dbt1 psql (8.4.3) You are now connected to database "dbt1". 4.dbt1=# create table t(a int); CREATE TABLE 5.dbt1=# insert into t values(1); INSERT 0 1 6.dbt1=# \c postgres psql (8.4.3) You are now connected to database "postgres". 7.postgres=# drop database dbt1; DROP DATABASE 8.postgres=# create database dbt1; CREATE DATABASE 9.postgres=# \c dbt1 psql (8.4.3) You are now connected to database "dbt1". 10.dbt1=# \d List of relations Schema | Name | Type | Owner --------+------+-------+---------- public | t | table | postgres (1 row) 11.dbt1=# select * from t; a --- 1 (1 row) Regards, Benny |