Migrating from MS-Access to Postgresql - Mailing list pgadmin-support

From Marc Cuypers
Subject Migrating from MS-Access to Postgresql
Date
Msg-id 001101c1d625$c2758420$177ba8c0@marc
Whole thread Raw
List pgadmin-support
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

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Can't edit tables with timestamps
Next
From: Jean-Michel POURE
Date:
Subject: Re: Can't edit tables with timestamps