| From: | Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de> |
|---|---|
| To: | mrojas_aquino(at)mail(dot)flashmail(dot)com |
| Cc: | PG Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: migrating from progress dbms |
| Date: | 2003-01-28 09:23:51 |
| Message-ID: | 20030128102351.4a622768.christoph.dalitz@hs-niederrhein.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 27 Jan 2003 15:15:50 -0500
pgsql-general-owner(at)postgresql(dot)org wrote:
>
> right now, the first thing we encounter is the fact that (at least in
> jdbc) all the table and column names needs to be beteewn double
> quotation marks.
>
Don't use double quotes unless you are asking for trouble!
Double quotes are used for case sensitive identifiers or identifiers
with whitespace characters. Usage of these features is not a good idea.
If you have found that you need them in queries, then your CREATE statements
used case sensitive table/attribute names. This will be a continuous source
of pain and I strongly recommend that you fix your CREATE statements.
Christoph Dalitz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ayhan | 2003-01-28 09:45:13 | PgSPI -- How "experimental" is it ? |
| Previous Message | Daryl Tester | 2003-01-28 09:16:55 | Re: list server problems? |