8/6/2023 0 Comments Postgresql rename table![]() ![]() See CREATE INDEX for details on the available parameters. This form changes one or more index-method-specific storage parameters for the index. An index that's marked as dependent on an extension is automatically dropped when the extension is dropped. This form marks the index as dependent on the extension, or no longer dependent on that extension if NO is specified. An attached index cannot be dropped by itself, and will automatically be dropped if its parent index is dropped. The named index must be on a partition of the table containing the index being altered, and have an equivalent definition. ATTACH PARTITIONĬauses the named index to become attached to the altered index. Note that system catalogs will not be moved by this command, use ALTER DATABASE or explicit ALTER INDEX invocations instead if desired. ![]() If the NOWAIT option is specified then the command will fail if it is unable to acquire all of the locks required immediately. This form also supports OWNED BY, which will only move indexes owned by the roles specified. All indexes in the current database in a tablespace can be moved by using the ALL IN TABLESPACE form, which will lock all indexes to be moved and then move each one. To change the tablespace of an index, you must own the index and have CREATE privilege on the new tablespace. This form changes the index's tablespace to the specified tablespace and moves the data file(s) associated with the index to the new tablespace. Renaming an index acquires a SHARE UPDATE EXCLUSIVE lock. If the index is associated with a table constraint (either UNIQUE, PRIMARY KEY, or EXCLUDE), the constraint is renamed as well. The RENAME form changes the name of the index. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |