highgo=# create table test (id int,name varchar(5));
CREATE TABLE
insert into test values (1,'aaaaa');
insert into test values (2,'bbbbb');
highgo=# select * from TEST;
id | name
----+-------
1 | aaaaa
2 | bbbbb
(2 rows)
highgo=# select * from test;
id | name
----+-------
1 | aaaaa
2 | bbbbb
(2 rows)
highgo=# select * from "test";
id | name
----+-------
1 | aaaaa
2 | bbbbb
(2 rows)
highgo=# select * from "TEST";
错误: 关系 "TEST" 不存在 第 15 个字符处
语句: select * from "TEST";
错误: 关系 "TEST" 不存在
LINE 1: select * from "TEST";
^
highgo=# create table "TESt2" (id int);
CREATE TABLE
highgo=# insert into test2 values (1);
错误: 关系 "test2" 不存在 第 13 个字符处
语句: insert into test2 values (1);
错误: 关系 "test2" 不存在
LINE 1: insert into test2 values (1);
^
highgo=# insert into "TESt2" values (1);
INSERT 0 1
highgo=#
CREATE TABLE
insert into test values (1,'aaaaa');
insert into test values (2,'bbbbb');
highgo=# select * from TEST;
id | name
----+-------
1 | aaaaa
2 | bbbbb
(2 rows)
highgo=# select * from test;
id | name
----+-------
1 | aaaaa
2 | bbbbb
(2 rows)
highgo=# select * from "test";
id | name
----+-------
1 | aaaaa
2 | bbbbb
(2 rows)
highgo=# select * from "TEST";
错误: 关系 "TEST" 不存在 第 15 个字符处
语句: select * from "TEST";
错误: 关系 "TEST" 不存在
LINE 1: select * from "TEST";
^
highgo=# create table "TESt2" (id int);
CREATE TABLE
highgo=# insert into test2 values (1);
错误: 关系 "test2" 不存在 第 13 个字符处
语句: insert into test2 values (1);
错误: 关系 "test2" 不存在
LINE 1: insert into test2 values (1);
^
highgo=# insert into "TESt2" values (1);
INSERT 0 1
highgo=#