[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] MySQL, PostgreSQL the names of the fields and case sensitive

I made a few mistakes in the code examples of scripts, but generally
all right ;)

Yes, of course, names for MySQL "correct". They must be taken as a basis.

Database, table, field and columns names in PostgreSQL are
case-independent, unless you created them with double-quotes
around their name, in which case they are case-sensitive.
Note: that PostgreSQL actively converts all non-quoted names to lower
case and so returns lower case in query results.

In MySQL, table names can be case-sensitive or not, depending on which
operating system you are using.

Therefore, if the PostgreSQL to create a table like this:

CREATE TABLE "Filename" ( "FilenameId" ..., "Name" ...);

then refer to it as

select filenameid, name from filename ...

will fail.

We should be

select "FilenameId","Name" from "Filename" ...

Therefore may be problems with backward compatibility.

with best regards

This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
Bacula-devel mailing list

This mailing list archive is a service of Copilotco.