Re: [SQL] Revoke on all database

2004-12-18 Thread Kretschmer Andreas
am Sat, dem 18.12.2004, um 12:54:33 -0500 mailte Henry Molina folgendes: > Hi all, > > Can I revoke "delete" on all database, something like this: on all databases, or on all tables in one database? > > REVOKE DELETE ON DATABASE mydb FROM PUBLIC; IMHO no, but you can walk through all database

[SQL] Revoke on all database

2004-12-18 Thread Henry Molina
Hi all, Can I revoke "delete" on all database, something like this: REVOKE DELETE ON DATABASE mydb FROM PUBLIC; thanks! -- Henry Molina R&D CMN Consulting ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index s

[SQL] diff databases

2004-12-18 Thread drdani
Hi, I'm looking for a tool which can compare structure of two databases and produce sql commands (ALTER, DROP, CREATE, etc. if needed) which could be used then to convert structure of one database to the other. I would like to use such a tool for postgresql databases especially. Daniel -

Re: [SQL] get branches & childs from database

2004-12-18 Thread Michael Fuhr
On Thu, Dec 16, 2004 at 10:23:23PM +0100, Marcus Krause wrote: > I'm trying to build up a menu by sending ONE query to database. See the contrib/ltree module in the PostgreSQL source, or in whatever package you must install to get the contributed modules. ltree provides easy ways to query tree-li