Subject Re: [firebird-support] create temporary table
Author Milan Babuskov
danyschaer wrote:
> How is the short path in Firebird for doing?:
> create temporary table Tbl_B as (select * from Tbl_A)
> This command creates (in PgSql) a new tmp table Tbl_B (visible only
> from the creator), and fill it with structure and contents of Tbl_A.

1. Open your favorite admin. tool and extract DDL for Tbl_A.
2. Change Tbl_A to Tbl_B
3. Add 'GLOBAL TEMPORARY' between CREATE and TABLE words
3. Run the CREATE... statement
4. Run INSERT INTO Tbl_B select * from Tbl_A

Milan Babuskov