0

I have a Postgres db. The tables are each in separate namespaces, which are named using two character state codes. The problem is this: for the state Indiana, the state code is "in". I am trying to execute this query:

SELECT city_name
FROM in.places

But I keep getting an error complaining about the 'in', presumably because there is a reserved keyword IN. How can I query the tables inside the 'in' namespace?

Improve this question
3
  • "IN", but I'd instead chose some other name. en.wikipedia.org/wiki/SQL_reserved_words Commented Jul 19, 2021 at 12:43
  • 1
    If you are stuck with this awful naming convention (the data should all be in one table), then use either "in".places or "in.place" -- whichever is appropriate. Commented Jul 19, 2021 at 12:45
  • Mandatory read Identifiers and Key Words in the Postgres manual Commented Jul 19, 2021 at 14:01
Related questions
4342
How do I UPDATE from a SELECT in SQL Server?
3327
How to add a column with a default value to an existing table in SQL Server?
2642
How to show tables in PostgreSQL?
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.