Date: 2018-06-05 15:53:33 +0200
From: Harman DBA <>
To: SQL devs <>
Version: 11.29.7 (Mar2018-SP1)
CC: kravchenko.anton86, martin.van.dinther, @PedroTadim

Last updated: 2019-04-30 12:36:03 +0200

Comment 26476

Date: 2018-06-05 15:53:33 +0200
From: Harman DBA <>

User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
Build Identifier:

We need to rename schema as we have challenges exporting database objects and importing it to a new database with a different schema name if the size of the database is huge(500GB +).

Reproducible: Always

Steps to Reproduce:

1.need to make a copy of the database with a different schema name
2.exporting database is taking longer time, to avoid, We plan to make a cold backup and rename schema
3.this can resolve if the schema can be renamed

Actual Results:

NA

Expected Results:

rename schema on a database

Ability to rename objects - need option to rename tables,rename schemas.

Comment 26485

Date: 2018-06-14 15:24:44 +0200
From: Martin van Dinther <<martin.van.dinther>>

Changed it to an enhancement request.

Suggested syntax: ALTER SCHEMA name RENAME TO new_name
See also: https://www.postgresql.org/docs/current/static/sql-alterschema.html

Renaming a table name is already recorded in:
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3567

Renaming a column name is already recorded in:
https://www.monetdb.org/bugzilla/show_bug.cgi?id=2478

Comment 26671

Date: 2018-11-07 11:48:07 +0100
From: @PedroTadim

A new SQL statement will be available in the next feature release of MonetDB for renaming schemas:

ALTER SCHEMA [IF EXISTS] oldname RENAME TO newname;

Comment 26844

Date: 2019-01-23 13:25:29 +0100
From: @sjoerdmullender

Will be in next feature release.

Comment 26959

Date: 2019-04-16 22:04:19 +0200
From: @sjoerdmullender

*** Bug #6698 has been marked as a duplicate of this bug. ***