Migrating from MS-Access to Postgresql

Поиск
Список
Период
Сортировка
От Marc Cuypers
Тема Migrating from MS-Access to Postgresql
Дата
Msg-id 001101c1d625$c2758420$177ba8c0@marc
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Can't edit tables with timestamps
Следующее
От: Jean-Michel POURE
Дата:
Сообщение: Re: Can't edit tables with timestamps