Re: [sqlalchemy] Re: create database name lowcase ?

[Massimiliano della Rovere]

Postgresql is case case insensitive unless you impose a specific casing
using " (double quotes): they are valid everywhere postgresql expects an
identifier (schema name, table name, column name, cte name, after AS, etc.

So it's all correct.
See
https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.quoted_name



Il ven 1 apr 2022, 04:01 oislone  ha scritto:

> I see.
> I didn't expect it to be so simple.
> I tried to debug sqlalchemy, but didn't find character conversion
> It turned out to be the default way of postgreql.
> Thanks for your instruction.
> 'Jonathan Vanasco' via sqlalchemy 於 2022/4/1 04:47 寫道:
>
> I'm not aware of any recent changes in the libraries that would cause that
> behavior.
>
> It may be how you are using the libraries or raw sql.
>
> PostgreSQL will convert database names to lowercase UNLESS the database
> name is in quotes.
>
> These will all create `abc`:
>
> CREATE DATABASE abc;
> CREATE DATABASE Abc;
> CREATE DATABASE ABc;
> CREATE DATABASE ABC;
> CREATE DATABASE aBc;
> CREATE DATABASE aBC;
> CREATE DATABASE abC;
>
> These will create two different databases:
>
> CREATE DATABASE "abc";
> CREATE DATABASE "Abc";
> CREATE DATABASE "ABc";
> CREATE DATABASE "ABC";
> .. etc..
>
>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/89e4aa92-c9c2-767d-6caf-dc0b77477a2a%40gmail.com
> 
> .
>

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/CADKhPGTYxvQRrXeYx%2BqvQEAiSByeanHaVJFgzofEOkdhASUvLg%40mail.gmail.com.

Re: [sqlalchemy] Re: create database name lowcase ?

[oislone]

I see.
I didn't expect it to be so simple.
I tried to debug sqlalchemy, but didn't find character conversion
It turned out to be the default way of postgreql.
Thanks for your instruction.

'Jonathan Vanasco' via sqlalchemy 於 2022/4/1 04:47 寫道:
I'm not aware of any recent changes in the libraries that would cause 
that behavior.


It may be how you are using the libraries or raw sql.

PostgreSQL will convert database names to lowercase UNLESS the 
database name is in quotes.


These will all create `abc`:

    CREATE DATABASE abc;
    CREATE DATABASE Abc;
    CREATE DATABASE ABc;
    CREATE DATABASE ABC;
    CREATE DATABASE aBc;
    CREATE DATABASE aBC;
    CREATE DATABASE abC;

These will create two different databases:

    CREATE DATABASE "abc";
    CREATE DATABASE "Abc";
    CREATE DATABASE "ABc";
    CREATE DATABASE "ABC";
    .. etc..




--
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper


http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/89e4aa92-c9c2-767d-6caf-dc0b77477a2a%40gmail.com.

[sqlalchemy] Re: create database name lowcase ?

['Jonathan Vanasco' via sqlalchemy]

I'm not aware of any recent changes in the libraries that would cause that 
behavior.

It may be how you are using the libraries or raw sql.

PostgreSQL will convert database names to lowercase UNLESS the database 
name is in quotes.

These will all create `abc`:

CREATE DATABASE abc;
CREATE DATABASE Abc;
CREATE DATABASE ABc;
CREATE DATABASE ABC;
CREATE DATABASE aBc;
CREATE DATABASE aBC;
CREATE DATABASE abC;

These will create two different databases:

CREATE DATABASE "abc";
CREATE DATABASE "Abc";
CREATE DATABASE "ABc";
CREATE DATABASE "ABC";
.. etc.. 


On Thursday, March 31, 2022 at 2:39:32 PM UTC-4 ois...@gmail.com wrote:

> Hi everyone, I have a question
>
> I use Postgresql
> Before creating a database, the name is uppercase and lowercase, and there 
> is no problem.
>
> Later SQLAlchemy was updated to version 1.4
> Don't know when the version started,
> When creating a database again, use uppercase and lowercase names, which 
> will always be lowercase database names.
> As a result, using drop database will fail.
>
> I am currently using:
> Arch-linux
> postgresql  V13.6-1
> sqlalcgemy V1.4.33
> pyscopg2V2.93
> dictalchemy3 V1.0.0
>
> E.g :
> engine = sqlalchemy.create_engine(
> "postgresql://xxx:yyy@localhost/postgres"
> )
> conn = engine.connect()
> conn.execute( "commit" )
> stt = "CREATE DATABASE ABCDEF"
> conn.execute(stt)
> conn.close()
>
> ===
> The database name will become abcdef
>
> I'm not sure if this is the reason for sqlalchemy or pyscopg2 ?
>
> Thank you everyone.
>

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/25fa8667-d4dd-43f8-a137-0c6a9125ccbbn%40googlegroups.com.