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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
