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)