mkmik commented on issue #1710:
URL:
https://github.com/apache/arrow-datafusion/issues/1710#issuecomment-1030007322
> If you create a table, the identifier is also lower cased at create time
the identifier is lowercased only if not quoted.
```
tmp1=> create table blarg(Foo int);
CREATE TABLE
tmp1=> \d blarg
Table "public.blarg"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
foo | integer | | |
tmp1=> create table blarg2("Foo" int);
CREATE TABLE
tmp1=> \d blarg2
Table "public.blarg2"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
Foo | integer | | |
```
To summarize, postgres schemas are case sensitive, but in the SQL syntax the
identifiers are lowercased when unquoted.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
