Re: Migrating from MS-Access to Postgresql

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

Browse pgadmin-support by date

  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