Note 1. SQL create table query works in below code.
Note 2. When I am connecting to greenplum through Katalon,
I am able to run Postgresql select query using below code.
Only Postgresql Create Table query does not work with below code.
I am not getting any error. MY Test case is passed. But in greenplum, the below table is not getting created. (b returns false)
boolean b = stm.execute(“create table <schema.table name> as select * from <schema.table name> WITH NO DATA”);
I tried using below query
CREATE TABLE <schema.table name>
(column_name 1 data_type 1
I tried execute(), executeUpdate(), executeQuery(). I did not get any success.
Please provide solution