From dnmurty@cal2.vsnl.net.in Mon Apr  10 19:23:40 2000
Received: from cal2.vsnl.net.in (cal2.vsnl.net.in [202.54.9.26])
	by hub.org (8.9.3/8.9.3) with ESMTP id PAA71278
	for <pgsql-interfaces@postgresql.org>;
	Mon, 10 Apr 2000 15:23:40 -0400 (EDT)
	(envelope-from dnmurty@cal2.vsnl.net.in)
Received: from oemcomputer (ppp116-74.pppcal.vsnl.net.in [203.197.116.74])
	by cal2.vsnl.net.in (8.9.0/8.9.0) with SMTP id AAA19170
	for <pgsql-interfaces@postgresql.org>;
	Tue, 11 Apr 2000 00:52:37 +0500 (GMT+0500)
Message-ID: <002101bfa322$3fc2a680$4a74c5cb@oemcomputer>
From: "D.N.MURTY" <dnmurty@cal2.vsnl.net.in>
To: <pgsql-interfaces@postgresql.org>
Subject: query from Murty
Date: Tue, 11 Apr 2000 00:53:21 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_001E_01BFA350.557C8BC0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Archive-Number: 200004/56

This is a multi-part message in MIME format.

------=_NextPart_000_001E_01BFA350.557C8BC0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

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 du=
pilaction of tables by the same name.
Do You have a solution to this problem ?

my e-mail number : dnmurty@vsnl.com


------=_NextPart_000_001E_01BFA350.557C8BC0
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3D"text/html; charset=3Dutf-8" http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>I created a programme in Visual Basic(I=
IS=20
Application) to create a table in the Access Database based on inputs from =
the=20
user.&nbsp; However I am not able to find out a way to&quot; make the code=
=20
check&nbsp; for existing tables&quot; to avoid dupilaction of tables by the=
 same=20
name.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>Do You have a solution to this problem=
=20
?</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2>my e-mail number : <A=20
href=3D"mailto:dnmurty@vsnl.com">dnmurty@vsnl.com</A></FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_001E_01BFA350.557C8BC0--




From shevlandj@kpi.com.au Tue Apr  11 00:56:29 2000
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



From byron.nikolaidis@home.com Tue Apr  11 03:52:25 2000
Received: from mail.rdc1.md.home.com (imail@ha1.rdc1.md.home.com [24.2.2.66])
	by hub.org (8.9.3/8.9.3) with ESMTP id XAA52922
	for <pgsql-interfaces@postgresql.org>;
	Mon, 10 Apr 2000 23:52:25 -0400 (EDT)
	(envelope-from byron.nikolaidis@home.com)
Received: from home.com ([24.4.141.52]) by mail.rdc1.md.home.com
	(InterMail vM.4.01.02.00 201-229-116) with ESMTP
	id <20000411035224.NSMN26983.mail.rdc1.md.home.com@home.com>;
	Mon, 10 Apr 2000 20:52:24 -0700
Message-ID: <38F2A105.E2EF3B38@home.com>
Date: Mon, 10 Apr 2000 23:50:29 -0400
From: Byron Nikolaidis <byron.nikolaidis@home.com>
Organization: @Home Network
X-Mailer: Mozilla 4.5 [en]C-AtHome0405  (Win95; 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/60



> "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
> 

Isn't there some kind of meta function such as odbc's SQLTables
available to your application?

Byron