centos 在Postgres中未找到任何名为table_name的关系

ryhaxcpt  于 2022-11-07  发布在  其他
关注(0)|答案(1)|浏览(120)

当我试图在模式中列出表boarding_passes的信息时,出现了一个错误:

demo=# \d boarding_passes
Did not find any relation named "boarding_passes".

下面是我的模式中所有关系的列表:

demo=# \dt bookings.*
             List of relations
  Schema  |      Name       | Type  | Owner
----------+-----------------+-------+-------
 bookings | aircrafts       | table | dba
 bookings | airports        | table | dba
 bookings | boarding_passes | table | dba
 bookings | bookings        | table | dba
 bookings | flights         | table | dba
 bookings | seats           | table | dba
 bookings | ticket_flights  | table | dba
 bookings | tickets         | table | dba
(8 rows)
oymdgrw7

oymdgrw71#

由于bookings显然不在您的search_path上,因此您需要使用

\d bookings.boarding_passes

相关问题