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
http://www.guacosoft.com