I am getting error when try to run the query with Postgres

ALTER TABLE EMP.USER DETACH PARTITION ID_CUST_111111 INTO DATA_PRTTN.ID_CUST_111111_USER

Wrapped by: java.sql.SQLException: SQL: ERROR: syntax error at or near "INTO"

CodePudding user response：

You don't place a partition in a table in PostgreSQL. A partition already is a table. So simply remove the INTO table_name from the statement. You can rename the partition after detaching, but I don't see much sense in that.