Loop through all views with PHP
Hi there,
my app is creating views for a certain task; now, I would like to run
on a regular basis a script which deletes these views. As they are
named with the date/hour/min/sec-appendix to make each view unique, I
don't know the names myself (Ok, I could stock the names in a
separate table as well).
Is there any way via PHP to loop through the whole set of views to
delete those with a specific name?
Thanks for any help.
Stef
Stefan Schwarzer writes:
Is there any way via PHP to loop through the whole set of views to
delete those with a specific name?
See pg_views.
In particular the viewname column.
am Mon, dem 18.06.2007, um 14:59:34 +0200 mailte Stefan Schwarzer folgendes:
Hi there,
my app is creating views for a certain task; now, I would like to run
on a regular basis a script which deletes these views. As they are
named with the date/hour/min/sec-appendix to make each view unique, I
don't know the names myself (Ok, I could stock the names in a
separate table as well).Is there any way via PHP to loop through the whole set of views to
delete those with a specific name?
You can scripting this,
http://people.planetpostgresql.org/greg/index.php?/archives/38-Scripting-with-psql.html#extended.
Modify the query there, change "WHERE relkind = 'r'" and compare with
'v' (VIEW).
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net