The Applier task can apply the following DDL operations to PostgreSQL targets:
ALTER TABLE
table_name
ADD
column_name
datatype
ALTER TABLE
table_name
ADD CONSTRAINT
constraint_name
[PRIMARY KEY|UNIQUE] (
column_name
)
ALTER TABLE
table_name
ALTER COLUMN
column_name
SET DATA TYPE
datatype
ALTER TABLE
table_name
ALTER COLUMN
column_name
SET NOT NULL
ALTER TABLE
table_name
DROP COLUMN
column_name
CASCADE
ALTER TABLE
table_name
DROP CONSTRAINT
constraint_name
CASCADE
CREATE INDEX
index_name
ON
table_name
(
column_name
)
CREATE TABLE
table_name
(
column_name
datatype
[NULL|NOT NULL] [PRIMARY KEY (
column_name
))
DROP INDEX
index_name
CASCADE
DROP TABLE
table_name
TRUNCATE
table_name
To replicate CREATE TABLE, ADD COLUMN, and RENAME COLUMN operations to PostgreSQL targets in Audit Apply mode, you must specify table and column names in all lowercase on the source. If you use uppercase, the Applier cannot replicate subsequent DML operations for the new table or column.
Data Replication does not enclose table names in quotation marks when replicating TRUNCATE TABLE operations. If the corresponding target tables have case-sensitive names, the Applier ends abnormally.