Get new column value using PostgreSQL sequence and serial column and keep referential integrity
Get new column value using PostgreSQL sequence and serial column and keep referential integrity
EXTRACT_LOAD
com.toolsverse.etl.driver.postgres.PostgresDriver
create_sequecne
dest
com.toolsverse.etl.core.task.common.SqlTask
com.toolsverse.etl.driver.postgres.PostgresDriver
CREATE SEQUENCE seq_config_property;
drop_table
dest
com.toolsverse.etl.core.task.common.SqlTask
com.toolsverse.etl.driver.postgres.PostgresDriver
drop table config_property_serial;
create_table
dest
com.toolsverse.etl.core.task.common.SqlTask
com.toolsverse.etl.driver.postgres.PostgresDriver
create table config_property_serial ( CP_NUM SERIAL PRIMARY KEY, NAME VARCHAR(255), DESCRIPTION VARCHAR(255), DEFAULT_VALUE VARCHAR(3000) )
config_property
select config_property.*, config_property_num as cfg_prop_num from config_property
config_property_serial
select CONFIG_PROPERTY_NUM as cp_num, name, description, default_value from config_property
config_value
select * from config_value
second_config_value
select config_property_num as con_prop_num, value from config_value
config_value_serial
select config_property_num as cp_num, value from config_value
config_property_serial
yes
config_property_test
config_property
yes
config_property_two
config_property
yes
config_value_test
config_value
yes
second_config_value
yes
config_value_serial
yes