本文展示了使用highgo数据库查询表'test'的具体方法，包括全字段查询及元数据查询，验证了表名大小写敏感性。
highgo=# select * from test;
id | name
----+------
1 |
2 |
3 |
(3 rows)
highgo=# select * from TEST;
id | name
----+------
1 |
2 |
3 |
(3 rows)
highgo=# select * from pg_tables where tablename='test';
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
------------+-----------+------------+------------+------------+----------+-------------
public | test | highgo | | t | f | f
(1 row)
highgo=# select * from pg_tables where tablename='TEST';
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
------------+-----------+------------+------------+------------+----------+-------------
(0 rows)
id | name
----+------
1 |
2 |
3 |
(3 rows)
highgo=# select * from TEST;
id | name
----+------
1 |
2 |
3 |
(3 rows)
highgo=# select * from pg_tables where tablename='test';
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
------------+-----------+------------+------------+------------+----------+-------------
public | test | highgo | | t | f | f
(1 row)
highgo=# select * from pg_tables where tablename='TEST';
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
------------+-----------+------------+------------+------------+----------+-------------
(0 rows)
扫一扫
3961
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
