Обсуждение: Another problem - exporting from access

Hi,

I also have another problem.. I exported a table from access to my pg7
DB but whenever I try to do ANYTHING with that table in pgsql it tells
me Error: Relation <mytablehere> doesn't exist.

What the heck is up with that?!

Help! :)

Craig

CB wrote:
>
> Hi,
>
> I also have another problem.. I exported a table from access to my pg7
> DB but whenever I try to do ANYTHING with that table in pgsql it tells
> me Error: Relation <mytablehere> doesn't exist.
>
> What the heck is up with that?!
>
> Help! :)
>
> Craig

Whenever you export a table from Access to PostgreSQL via ODBC,
the export generates case-sensitive table and field names which
have to be quotes in PostgreSQL. So, for example, your queries in
psql would be like:

SELECT "Employees"."Employee" FROM "Employees" WHERE
"Employees"."Salary" > 100000;

instead of:

SELECT employees.employee FROM employees WHERE employees.salary >
100000;

Hope that helps,

Mike Mascari