postgresql - Postgres : How to view contents of a table?

This question already has answers here:

Cannot simply use PostgreSQL table name (“relation does not exist”)

(12个答案)



postgres - select * from existing table - psql says table does not exist

(2个答案)



currval Function in PostgreSQL complaining that “column does not exist”

(1个答案)



PostgreSQL “Column does not exist” but it actually does

(3个答案)



Error: Column does not exist

(1个答案)


3年前关闭。




这是我有的吗？

contacts=# \l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges
-----------+----------+----------+------------+------------+-----------------------
 contacts  | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 |
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
(4 rows)

contacts=# \d
             List of relations
 Schema |     Name      | Type  |  Owner
--------+---------------+-------+----------
 public | SequelizeMeta | table | postgres
(1 row)

contacts=# select * from SequelizeMeta;
ERROR:  relation "sequelizemeta" does not exist
LINE 1: select * from SequelizeMeta;
                      ^
contacts=# contacts=# select * from public.SequelizeMeta;
ERROR:  relation "public.sequelizemeta" does not exist
LINE 1: select * from public.SequelizeMeta;
                      ^

如何阅读SequelizeMeta的内容？

谢谢

最佳答案

基于wildplasser命令，这是我必须要做的。谢谢wildplasser

contacts=# select * from "SequelizeMeta";
 name
------
(0 rows)

关于postgresql - Postgres : How to view contents of a table?，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/46393011/