Received: from alcanet.com.au (news.alcanet.com.au [203.62.196.10])
	by hub.org (8.9.3/8.9.1) with ESMTP id UAA18917
	for <pgsql-interfaces@postgresql.org>;
	Sun, 18 Apr 1999 20:47:03 -0400 (EDT)
	(envelope-from Dennis.Chen@alcatel.com.au)
Received: by border.alcanet.com.au id <40357>; Mon, 19 Apr 1999 10:33:11 +1000
Date: Mon, 19 Apr 1999 10:45:21 +1000
From: Dennis Chen <Dennis.Chen@alcatel.com.au>
Subject: importing tables through ODBC having errors
To: pgsql-interfaces@postgresql.org
Message-Id: <99Apr19.103311est.40357@border.alcanet.com.au>
Organization: Alcatel
MIME-version: 1.0
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7bit
X-Accept-Language: en

Hi,

I was tring to use insight's ODBC driver on Windows NT.

I used VisData to browse the Postgres Database I connected to.
I was able to see those tables I defined in Postgres  database, there
wasn't any problem.

Subsequently, I imported some tables from MS Acess and
I was still able to see them in VisData. However, when I back to
the host and use psql to check those tables I imported. There was
problem. I type in \d *, the errors were:

Can't find Table <xxx1>
Can't find Table <xxx2>

which are imported tables.



Cheers

Dennis