Re: [SQL] diff databases

2004-12-28 Thread Robert Treat
On Saturday 18 December 2004 09:23, [EMAIL PROTECTED] wrote: > 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

[SQL] simulating global temp tables in plpgsql functions

2004-12-28 Thread Dennis Sacks
Hi, Once again I'm translating an oracle stored proc that uses a global temporary table. Using postgresql's nonglobal temp tables from plpgsql functions is painful - translating all the queries into strings passed to execute. It is error prone, and it makes the queries less readable, thus less