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



当我试图在我的模式中列出关于表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)

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

d bookings.boarding_passes

相关内容

最新更新