postgresql key
- 作者: 1986年7月29号的梦魇
- 来源: 51数据库
- 2020-09-25
创建表
[postgres@web1 data]$ psql -U zhongwc -d zwcdb -h 192.168.1.203 -p 1521
Password for user zhongwc:
psql (9.2.2)
Type "help" for help.
zwcdb=> create table t_zhongwc(pid integer,pname varchar(32),constraint zhongwc_pid_pk primary key(pid));
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "zhongwc_pid_pk" for table "t_zhongwc"
CREATE TABLE
zwcdb=>
zwcdb=> select * from t_zhongwc;
pid | pname
-----+-------
(0 rows)
[postgres@web1 data]$ psql -U zhongwc -d zwcdb -h 192.168.1.203 -p 1521
Password for user zhongwc:
psql (9.2.2)
Type "help" for help.
zwcdb=> create table t_zhongwc(pid integer,pname varchar(32),constraint zhongwc_pid_pk primary key(pid));
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "zhongwc_pid_pk" for table "t_zhongwc"
CREATE TABLE
zwcdb=>
zwcdb=> select * from t_zhongwc;
pid | pname
-----+-------
(0 rows)
推荐阅读
