Hi.
> From: Govender, Maya
> To: pgsql-odbc@postgresql.org
> Sent: Wednesday, August 15, 2007 7:50 PM
> Subject: [ODBC] Psql DBC -08.02.0400 problem, only public schema can be viewed.
>
>
> Greetings,
>
> Current environment setup:
>
> OS - Solaris 9 Sparc 64 bit
> Application - SAS 9
> Odbc Driver - UNIX ODBC 2.2
> Postgres driver - Psqlodbc-08.02.0400
>
> Problem situation :
>
> Requirements - Access postgres 8.1.3 database from sas ( CRM application ) using unixODBC
> and psqlodbc compiled as 64 bit because sas is installed as 64 bit
Cool:-)
> Current situation - the above is in place , I can access all data/tables in the public
> schema only, all other schema's cannot be accessed from sas.
Does on the ShowSystemTables of odbc.ini help you?
Regards,
Hiroshi Saito