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(at)tampabay(dot)rr(dot)com [mailto:ghowe1(at)tampabay(dot)rr(dot)com]
> Sent: 12 April 1999 12:34
> To: Dave Page
> Cc: pgsql-interfaces(at)postgresql(dot)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.