Hi Glenn,
'Addresses' is not the same as 'addresses'. Try:
SELECT * FROM "Addresses";
That should be OK.
Dave.
> -----Original Message-----
> From: ghowe1@tampabay.rr.com [mailto:ghowe1@tampabay.rr.com]
> Sent: 12 April 1999 12:34
> To: Dave Page
> Cc: pgsql-interfaces@postgresql.org
> Subject: RE: Problem migrating MSAccess97 table
>
>
> Hi Dave,
>
> First of all, thanks for the reply.
>
>
> Second, I'm quite sure I am accessing the same database.
> Infact, from psql I
> can list the table, just cannot access it.
> ---------------------------------------------
>
> contacts=> \dt
>
> Database = contacts
> +------------------+----------------------------------+----------+
> | Owner | Relation | Type |
> +------------------+----------------------------------+----------+
> | postgres | Addresses | table |
> | postgres | msysconf | table |
> | postgres | pga_forms | table |
> | postgres | pga_queries | table |
> | postgres | pga_reports | table |
> | postgres | pga_scripts | table |
> +------------------+----------------------------------+----------+
> contacts=> select * from addresses;
> ERROR: addresses: Table does not exist.
> contacts=>
> ------------------------------------------------------------
> Furthermore, I can access the table from within pgadmin using the data
> button. I cannot access the table from any other ODBC application
> though(even though I am using the same odbc system dsn).
>
> Attached is the database migration events.