sql - Postgresql tables exists, but getting "relation does not exist" when querying -

i have postgresql db number of tables. if query:

select column_name information_schema.columns table_name="my_table";

i list of columns returned properly.

however, when query:

select * "my_table";

i error:

(programmingerror) relation "my_table" not exist 'select *\n    "my_table"\n' {}

any thoughts on why can columns, can't query table? goal able query table.

you have include schema if isnt public one

select * <schema>."my_table"

or can change default schema

show search_path; set search_path my_schema;

check table schema here

select * information_schema.columns

for example if table on default schema public both works ok

select * parroquias_region select * public.parroquias_region

but sectors need specify schema

select * map_update.sectores_point

First Image