1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

changlei:build ChangLei$ psql -d postgres

psql (8.2.15)

Type "help" for help.

postgres=＃ create database test; # 創建數據庫test

CREATE DATABASE

postgres=＃ \c test # 連接進入test數據庫

You are now connected to database "test" as user "ChangLei".

test=＃ create table foo(id int, name varchar); # 創建表foo

CREATE TABLE

test=＃ \d # 顯示當前數據庫test中所有表

List of relations

Schema | Name | Type | Owner | Storage

-------- ------ ------- ---------- -------------

public | foo | table | ChangLei | append only

(1 row)

test=＃ insert into foo values(1, 'hawq'),(2, 'hdfs');

INSERT 0 2

test=＃ select * from foo; # 從表foo中選擇數據

id | name

---- ------

1 | hawq

2 | hdfs

(2 rows)

如果想删除表或者數據庫的話可以使用drop語句。

test=＃ drop table foo;

DROP TABLE

test=＃ \d

No relations found.

test=＃ drop database test; # 因為現在在test數據庫中，所以不能删除

ERROR: cannot drop the currently open database

test=＃ \c postgres # 首先連接到postgres數據庫，然後删除test數據庫

You are now connected to database "postgres" as user "ChangLei".

postgres=＃ drop database test;

DROP DATABASE