Re: underscore problem

From: "postgresql" <pgsql@symcom.com>


> Is there anywhere in the docs that says we should not use an
> underscore in a table name?
>
> select acode from FC_Client_Info where jobno = '1234';
> fails with a warning that fc_client_info does not exist
> notice the lower case. If I quote the table
>
> select acode from "FC_Client_Info" where jobno = '1234';
> the select works fine

It's the case not the underscore. PG lower-cases table/field names both on
creation and on queries. You can create/access mixed-case tables by quoting
them, as you've discovered.

This usually crops up converting from a different DB to Postgresql.

- Richard Huxton