1. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

[SQL] Are PostgreSQL column names case-sensitive?

Discussão em 'Outras Linguagens' iniciado por Stack, Outubro 4, 2024 às 11:52.

  1. Stack

    Stack Membro Participativo

    I have a db table say, persons in Postgres handed down by another team that has a column name say, "first_Name". Now am trying to use PG commander to query this table on this column-name.

    select * from persons where first_Name="xyz";


    And it just returns


    ERROR: column "first_Name" does not exist

    Not sure if I am doing something silly or is there a workaround to this problem that I am missing?

    Continue reading...

Compartilhe esta Página