From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Best practice to move from MySQL to PostgreSQL |
Date: | 2010-12-02 07:49:15 |
Message-ID: | id7j1q$3li$1@dough.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Guenther Boelter, 02.12.2010 05:04:
> so a query looks like this
>
> SELECT BelegNummer, BelegDatum FROM rechnungen ORDER BY BelegDatum ASC;
>
> This will not work with PostgreSQL, because PostgreSQL will change all fieldnames to lowercase, right?
> Means, I've to change all fieldnames to lowercase like belegnummer, belegdatum ....
No you don't need to change the statements - at least not if they *don't* use doubles quotes.
As long as you don't use double quotes, the names are not case-sensitive (as required by the standard)
So just make sure you don't quote your table and column names and you should be fine.
The following statements are equivalent:
SELECT BELEGNUMMER FROM RECHNUNGEN
select belegnummer from rechnungen
SELECT belegnummer FROM rechnungen
SELECT BeLeGnUmMer FROM rechnungen
...
> Should I change my queries to something like this:
>
>> SELECT belegnummer, belegdatum FROM rechnungen ORDER BY belegdatum ASC;
No need to do that.
Regards
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2010-12-02 11:58:03 | Re: Get server's time in UTC time zone, in ISO 8601 format |
Previous Message | Guenther Boelter | 2010-12-02 04:04:36 | Best practice to move from MySQL to PostgreSQL |