|
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
|