Subject Re: [firebird-support] insert from select in psql
Author Ann Harrison
W O <sistemas2000profesional@...> wrote:

> If the tables have always the same name you don't need the EXECUTE STATEMENT
>> I found a simple solution:
>> EXECUTE STATEMENT 'insert into A select * from B';

The execute statement form works better if the format of the tables is volatile. You avoid the "object in use" error if the procedure has been compiled.

Good luck,