CODEWITHSUNDEEP
postgresqlunixcentospsql
karver35
karver35

Reputation: 31

Did not find any relation named table_name in Postgres

When I'm trying to list information about the table boarding_passes in my schema I get an error:

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

Here is the list of all relations in my schema:

 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)

Upvotes: 1

Views: 1197

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247830

Since bookings is obviously not on your search_path, you need to use

\d bookings.boarding_passes

Upvotes: 1

Related Questions