Skip site navigation (1) Skip section navigation (2)

Re: query from Murty

From: Joe Shevland <shevlandj(at)kpi(dot)com(dot)au>
To: "D(dot)N(dot)MURTY" <dnmurty(at)cal2(dot)vsnl(dot)net(dot)in>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: query from Murty
Date: 2000-04-11 01:00:45
Message-ID: 38F2793D.81A90488@kpi.com.au (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)vsnl(dot)com
> 

-- 
Joe Shevland
Principal Consultant
KPI Logistics Pty Ltd
http://www.kpi.com.au
mailto:shevlandj(at)kpi(dot)com(dot)au

In response to

pgsql-interfaces by date

Next:From: brianbDate: 2000-04-11 01:02:45
Subject:
Previous:From: D.N.MURTYDate: 2000-04-10 19:23:21
Subject: query from Murty

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group