4/3/2023 0 Comments Postgres app owner app user![]() ![]() The database-specific default overrides whatever setting is present in nf or has been received from the postgres command line. ![]() Whenever a new session is subsequently started in that database, the specified value becomes the session default value. The remaining forms change the session default for a run-time configuration variable for a PostgreSQL database. Tables and indexes in non-default tablespaces are unaffected. The new default tablespace must be empty for this database, and no one can be connected to the database. This command physically moves any tables or indexes in the database's old default tablespace to the new tablespace. Only the database owner or a superuser can do this you must also have create privilege for the new tablespace. The fourth form changes the default tablespace of the database. (Note that superusers have all these privileges automatically.) To alter the owner, you must own the database and also be a direct or indirect member of the new owning role, and you must have the CREATEDB privilege. The third form changes the owner of the database. (Connect to a different database if you need to do that.) Only the database owner or a superuser can rename a database non-superuser owners must also have the CREATEDB privilege. The second form changes the name of the database. (See below for details.) Only the database owner or a superuser can change these settings. The first form changes certain per-database settings. ALTER DATABASE changes the attributes of a database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |