|
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.
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
|
