Thread: Problem selecting data

Problem selecting data

From
"Garry Rothert"
Date:
Hi
I've migrated an access database into PostgreSQL using the migration. Everything
seems to have worked, but I can't see the tables in the PGADMIN tree. Also when I try
and select the data I get the following.

ERROR: Relation "tablename" does not exist.

The migration imported 6 tables and I cannot query any of them. Any help would be
greatly appreciated.

This email and any files transmitted with it are privileged, confidential, subject to
copyright and intended solely for the use of the individual or entity to whom they
are addressed. Views expressed are those of the user and not necessarily those
of DPH Engineering Inc.. Any unauthorized use, copying, review or disclosure is
prohibited. Please notify the sender immediately if you have received this
communication in error. Thank you for your assistance and co-operation.


Re: Problem selecting data

From
"Dave Page"
Date:

> -----Original Message-----
> From: Garry Rothert [mailto:garry.rothert@dph.ab.ca]
> Sent: 07 February 2003 15:36
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Problem selecting data
>
>
> Hi
> I've migrated an access database into PostgreSQL using the
> migration. Everything
> seems to have worked, but I can't see the tables in the
> PGADMIN tree. Also when I try
> and select the data I get the following.

Hi Garry,

What do you see in the tree?

> ERROR: Relation "tablename" does not exist.

Did the tables have mixed case names, or odd characters (such as spaces)
in them? If so, try double quoting their names in your SQL.
Alternatively, rerun the migration with the option to shift the names to
lower case switched on (it's on the first page).

Regards, Dave