pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedquery from Murty
3+ messages / 3 participants
[nested] [flat]
* query from Murty
@ 2000-04-10 19:23 D.N.MURTY <dnmurty@cal2.vsnl.net.in>
0 siblings, 2 replies; 3+ messages in thread
From: D.N.MURTY @ 2000-04-10 19:23 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: query from Murty
@ 2000-04-11 01:00 Joe Shevland <shevlandj@kpi.com.au>
parent: D.N.MURTY <dnmurty@cal2.vsnl.net.in>
1 sibling, 0 replies; 3+ messages in thread
From: Joe Shevland @ 2000-04-11 01:00 UTC (permalink / raw)
To: D.N.MURTY <dnmurty@cal2.vsnl.net.in>; +Cc: 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@vsnl.com
>
--
Joe Shevland
Principal Consultant
KPI Logistics Pty Ltd
http://www.kpi.com.au
mailto:shevlandj@kpi.com.au
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: query from Murty
@ 2000-04-11 03:50 Byron Nikolaidis <byron.nikolaidis@home.com>
parent: D.N.MURTY <dnmurty@cal2.vsnl.net.in>
1 sibling, 0 replies; 3+ messages in thread
From: Byron Nikolaidis @ 2000-04-11 03:50 UTC (permalink / raw)
To: D.N.MURTY <dnmurty@cal2.vsnl.net.in>; +Cc: pgsql-interfaces
> "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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-04-11 03:50 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-10 19:23 query from Murty D.N.MURTY <dnmurty@cal2.vsnl.net.in>
2000-04-11 01:00 ` Joe Shevland <shevlandj@kpi.com.au>
2000-04-11 03:50 ` Byron Nikolaidis <byron.nikolaidis@home.com>
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