0

A SQL coding challenge provided a database; every table was accessible when passed as a string using double quotes and not when passed as a word as I am normally used to.

This did not work:

SELECT * FROM Athletes;

Error message: relation does not exist.

But this worked and I don't understand why:

SELECT * FROM "Athletes";

Was this defined during the database creation? Or is this from PostgreSQL?

Digvijay Patil
  • 37
  • 4
  • [ask] [Help] [mre] [How much research effort is expected of Stack Overflow users?](https://meta.stackoverflow.com/q/261592/3404097) – philipxy Nov 23 '22 at 04:45
  • 1
    [Identifiers and Key Words](https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS) in the Postgres manual –  Nov 23 '22 at 07:04
  • 2
    "*Was this defined during the database creation*" - yes, you created the table with double quotes, now you are forced to always use them. –  Nov 23 '22 at 07:05

0 Answers0