Postgresql arbitrary queries

Question

I have pgAdmin 4 and PostgreSQL 10.

I can't execute a query without quote marks i.e. I want to excute this

select * from table

but it only works if I use

select * from databasename."table"

How can I remove this restriction?

The name of the table is Complexitie. I was using postgresql the last year and I remember I could write queries in a simple way without mandatory syntax things like case senstive, mandatory quotes.

I read something about to setup arbitrary SQL queries en Postgres, but I can not find steps to configure it. thanks

Answer 1

You probably used a keyword as name of your table. You will find the complete list of those keywords in that page of the documentation.

From my experience, the most frequent ones are columns named end or start.

Have a nice day