RE: Problem migrating MSAccess97 table

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.