Postgres column comment of a table in a specific schema [duplicate]
Qualify the table with the schema name
select *
from my_schema.aircraft
use:
SET search_path TO myschema; or
SET search_path TO myschema, myschemab;
https://www.postgresql.org/docs/9.4/static/ddl-schemas.html