Re: Problem selecting data

> -----Original Message-----
> From: Garry Rothert [mailto:garry(dot)rothert(at)dph(dot)ab(dot)ca]
> Sent: 07 February 2003 15:36
> To: pgadmin-support(at)postgresql(dot)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