Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support

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:


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:
>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
>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?

Rivendell Software - Dynamic Web Solutions
tel 902.461.0720
cell 902.802.0867

pgadmin-support by date

Next:From: Dave PageDate: 2002-03-28 13:57:47
Subject: Re: Migrating from MS-Access to Postgresql
Previous:From: Dave PageDate: 2002-03-28 12:27:50
Subject: Re: Can't edit tables with timestamps

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group