Received: from www.kpi.com.au (www.kpi.com.au [203.39.132.210])
	by hub.org (8.9.3/8.9.3) with ESMTP id UAA26450
	for <pgsql-interfaces@postgresql.org>;
	Mon, 10 Apr 2000 20:56:29 -0400 (EDT)
	(envelope-from shevlandj@kpi.com.au)
Received: from kpi.com.au (ws06.kpi.com.au [203.39.132.219])
	by www.kpi.com.au (8.9.3/8.9.3) with ESMTP id KAA31692;
	Tue, 11 Apr 2000 10:58:56 +1000 (EST)
	(envelope-from shevlandj@kpi.com.au)
Message-ID: <38F2793D.81A90488@kpi.com.au>
Date: Tue, 11 Apr 2000 11:00:45 +1000
From: Joe Shevland <shevlandj@kpi.com.au>
Organization: KPI Logistics Pty Ltd
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: "D.N.MURTY" <dnmurty@cal2.vsnl.net.in>
CC: pgsql-interfaces@postgresql.org
Subject: Re: query from Murty
References: <002101bfa322$3fc2a680$4a74c5cb@oemcomputer>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200004/58

SELECT * FROM pg_tables WHERE tablename NOT LIKE 'pg_%'

will list the tables present in the database... you can
go from there.

Cheers,
Joe

> "D.N.MURTY" wrote:
> 
> I created a programme in Visual Basic(IIS Application) to create a table in
> the Access Database based on inputs from the user.  However I am not able to
> find out a way to" make the code check  for existing tables" to avoid
> dupilaction of tables by the same name.
> Do You have a solution to this problem ?
> 
> my e-mail number : dnmurty@vsnl.com
> 

-- 
Joe Shevland
Principal Consultant
KPI Logistics Pty Ltd
http://www.kpi.com.au
mailto:shevlandj@kpi.com.au