From: | Dino Nardini <dnardini(at)rivendellsoftware(dot)com> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, "'Marc Cuypers'" <m(dot)cuypers(at)pandora(dot)be>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Migrating from MS-Access to Postgresql |
Date: | 2002-03-28 13:45:15 |
Message-ID: | 5.1.0.14.2.20020328094303.00aea248@pop.rivendell.ns.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello,
I ran into similiar problems when migrating tables from MSSQL to
Postgres. Typically I create table names such as "TableName" and column
names such as "TableID" in MSSQL. If there exists a table called
"TableName" and a column called "TableID" why won't the following query
work in postgres:
SELECT TableID FROM TableName
I guess that my question is: why does Postgres muck around with the
case? Double quoting all tables and columns in a database that contains
dozens of tables is far too much work, and I don't understand why I need to
drop all my labels to lowercase in the DB. Is there no way to override
this behavior?
Cheers... Dino
At 09:10 AM 28/03/2002 +0000, Dave Page wrote:
>Hi,
>
>Either change your query to:
>
>SELECT * FROM "Invoices"
>
>or, on the first step in the Migration Wizard, use the options to shift
>names to lower case, and re-migrate your data.
>
>Of course, if you only have a few tables/columns you could just rename
>them in pgAdmin.
>
>Regards, Dave.
>-----Original Message-----
>From: Marc Cuypers [mailto:m(dot)cuypers(at)pandora(dot)be]
>Sent: 28 March 2002 06:57
>To: pgadmin-support(at)postgresql(dot)org
>Subject: [pgadmin-support] Migrating from MS-Access to Postgresql
>
>Hi,
>
>I migrated a few tables to postgresql. Everything migrated fine, but
>tablenames that contain capitals are converted just as is. When I create
>a query, postgresql doesn't seem to use those captitals and converts them
>to lowercase. This makes that the table is not found in the database and
>I get an error. I the database is a table 'Invoices', so the respons to
>the query 'select * from Invoices' is 'Relation invoices doesn't exist' .
>
>Can someone help me with this?
>
>Thanx,
>
>Marc
_____________________________________
Rivendell Software - Dynamic Web Solutions
www.rivendellsoftware.com
tel 902.461.0720
cell 902.802.0867
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-03-28 13:57:47 | Re: Migrating from MS-Access to Postgresql |
Previous Message | Dave Page | 2002-03-28 12:27:50 | Re: Can't edit tables with timestamps |