![]() The directory path should be defined as an absolute path. It will use the directory defined under the LOCATION clause. It can be created by superusers only, and they can assign the ownership of the tablespace to non-superusers. The name defined is the user who will own the newly created PostgreSQL tablespace.If the user_name is not defined, then the user executing the statement will own the newly created PostgreSQL tablespace. We can not define the name which begins with pg_ the names starting with pg_ are reserved for PostgreSQL system tablespaces. The name of the PostgreSQL tablespace to create a new PostgreSQL tablespace. Let’s illustrate the following syntax for creating a new tablespace: In order to read and write data from/to the directory, the system user must own this directory. The path defined under the LOCATION clause is used to create the PostgreSQL tablespace this path is an absolute path to an empty. ![]() The SQL statement also allows us to assign the ownership of it to a different user by specifying the name in the OWNER clause.The user who executes the CREATE TABLESPACE is the owner of the PostgreSQL tablespace.Hadoop, Data Science, Statistics & others
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |