| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Jeff Eckermann" <jeff_eckermann(at)yahoo(dot)com>, "Stephen Frost" <sfrost(at)snowman(dot)net>, "Andre Felipe Machado" <andremachado(at)techforce(dot)com(dot)br> |
| Cc: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: Tables/Columns in upper-case? |
| Date: | 2004-01-22 08:48:00 |
| Message-ID: | 03AF4E498C591348A42FC93DEA9661B872057B@mail.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
> -----Original Message-----
> From: Jeff Eckermann [mailto:jeff_eckermann(at)yahoo(dot)com]
> Sent: 22 January 2004 00:10
> To: Stephen Frost; Andre Felipe Machado
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Tables/Columns in upper-case?
>
> Take a look at the Database Migration Wizard that comes with
> PgAdminII (and PgAdminIII as well? I haven't checked that
> out).
Nope, no migration wizard in pga3. :-( If there are any bored C++
programmers out there though...
As for the quotes, neither psqlodbc or PostgreSQL will fold them to
uppercase - Access must be doing that.
The rule is, if unquoted, an object name may contain a through z, 0
though 9 or an underscore. If you try to use upper case characters, they
will be folded to lowercase by the server. To use uppercase, or any
other characters in identifiers you must quote them.
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-01-22 10:32:31 | Re: Idle connections - Too many clients connected already |
| Previous Message | Philippe Lang | 2004-01-22 06:57:58 | Idle connections - Too many clients connected already |