How to create postgres table in talend using create query

Question

i am trying to create table in talend using below code i see no error but in database this table is not getting created do $$ declare begin execute 'DROP TABLE IF EXISTS tname'; execute 'CREATE TABLE IF NOT EXISTS tname (ACTIVITY VARCHAR(32))'; end $$ ;

Please help me i am new in Talend

Answer 1

Should be something like this

DO
$$ 
DECLARE BEGIN 
    EXECUTE  'DROP TABLE IF EXISTS tname';      
    EXECUTE  'CREATE TABLE IF NOT EXISTS tname (ACTIVITY VARCHAR(32))'; 
END; 
$$