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