Product: Aqua Data Studio

Version: 11.0.0-rc-75

Build #: 26492

 

Temp table clause is missing for ER Diagram Generator. Create a temp table in ParAccel/PostgreSQL and try to script it. You can see that the TEMP/TEMPORARY clause is missing and table is scripted as an ordinary table.

 

1. Connect to ParAccel Analytic Platform

2.  Create a temporary table. For e.g

 

CREATE TEMPORARY TABLE "tmp"  ( 

"tmp_col_1" varchar(25) NOT NULL,

"tmp_col_2" float8 NOT NULL 

)

 

3.  Click on Tools --> ER Diagram Generator

 

4. Script tables including the temporary table you just created

 

5. Select the temp table properties and click on the tab SQL Preview and you can see that the Temporary clause is missing in the ER Model