Files
2026-07-13 12:32:25 +08:00

17 lines
635 B
Plaintext

ALTER PUBLICATION $name$ ADD $publication_object$ [ , ... ]
ALTER PUBLICATION $name$ SET $publication_object$ [ , ... ]
ALTER PUBLICATION $name$ DROP $publication_object$ [ , ... ]
ALTER PUBLICATION $name$ SET ( { $publication_parameter$ [ = $value$ ] } [ , ... ] )
ALTER PUBLICATION $name$ OWNER TO { $new_owner$ | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER PUBLICATION $name$ RENAME TO $new_name$
where $publication_object$ is:
{ TABLE { ONLY $table_name$ | $table_name$ [ * ] } [ ( $column_name$ [ , ... ] ) ] [ WHERE ( $expression$ ) ] } [ , ... ] |
TABLES IN SCHEMA { $schema_name$ | CURRENT_SCHEMA } [ , ... ]