Postgresql rename table how to#
Postgresql rename table update#
Postgresql rename table code#

PostgreSQL data typesĬomplete reference of the PostgreSQL data types documentation. DROP TABLE referenceĬomplete reference of the DROP TABLE command documentation. ALTER TABLE referenceĬomplete reference of the ALTER TABLE command documentation. CREATE TABLE referenceĬomplete reference of the CREATE TABLE command documentation. The official documentation on the postgresql_copy module. postgresql_copy – Copy data between a file/program and a PostgreSQL table The official documentation on the postgresql_privs module. postgresql_privs – Grant or revoke privileges on PostgreSQL database objects The official documentation on the postgresql_owner module. postgresql_owner – Change an owner of PostgreSQL database object The official documentation on the postgresql_tablespace module. postgresql_tablespace – Add or remove PostgreSQL tablespaces from remote hosts The official documentation on the postgresql_info module. postgresql_info – Gather information about PostgreSQL servers The official documentation on the postgresql_sequence module. but these final few statements should be fast.ĪLTER TABLE 'table' RENAME TO 'table_old' ĪLTER TABLE 'table_new' RENAME TO 'table' Įxtra bonus: Postgres actually supports transactional DDL, unlike MySQL, so in case you need to ROLLBACK the above transaction, you may safely do so.See also postgresql_sequence – Create, drop, or alter a PostgreSQL sequence RENAME TO command takes an Access Exclusive lock on 'table', LOCK TABLE 'table' IN SHARE ROW EXCLUSIVE mode

For example: ALTER TABLE orderdetails RENAME TO orderinformation This ALTER TABLE example will rename the orderdetails table to orderinformation.

Postgresql rename table how to#

those changes may be lost during this switchover process. Let's look at an example that shows how to rename a table in PostgreSQL using the ALTER TABLE statement.

Postgresql rename table update#

INSERT / UPDATE / DELETE'ing from the original table, otherwise You probably want to make sure that no one else is

Postgresql rename table code#

You can use the same workaround as in your MySQL-specific code Postgres supports roughly the same syntax and will have similar locking behavior. acquires an ACCESS EXCLUSIVE lock on each table it operates on', so in the first SQL block you posted, any other clients attempting to access the table after that time will be blocked until your INSERT finishes and you COMMIT. Right, the TRUNCATE TABLE command you are performing '.