On using psql on Linux, when I connect with it... create

Question

On using psql on Linux, when I connect with it... create

table "FOOBAR" (col text);
Creates the table with an uppercase name.

create table FOOBAR (col text);
Creates the table with a lowercase name.

create table "foobar" (col text);
Creates the table with a lowercase name.

create table foobar (col text);
Creates the table with a lowercase name.

Does this check out?

#programming #russian

0

05.01.2024

1 ответов

21 просмотр

Kirk · Accepted Answer

Kirk

Yes. It is basically 100% opposite of Oracle, and I think ONE of the places where it deviates from the SQL Standard. It assumes tables are lowercase, unless quoted. If quoted, it requires an exact case match. So, without quotes, it is converted to lowercase by default.

0

11 месяцев назад

169 похожих чатов

On using psql on Linux, when I connect with it... create

1 ответов

Похожие вопросы