From: Joe Shevland <shevlandj@kpi.com.au>
To: D.N.MURTY <dnmurty@cal2.vsnl.net.in>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: query from Murty
Date: Tue, 11 Apr 2000 11:00:45 +1000
Message-ID: <38F2793D.81A90488@kpi.com.au> (raw)
References: <002101bfa322$3fc2a680$4a74c5cb@oemcomputer>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: shevlandj@kpi.com.au, dnmurty@cal2.vsnl.net.in
Subject: Re: query from Murty
In-Reply-To: <38F2793D.81A90488@kpi.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox