Category: How-To Guides

Below is the command to change the owner of a database. You need to login as superuser to run the

You cannot change the name of a database that you are currently connected to. To rename a database, login as

Use below commands to create a new database in the Redshift Cluster. CREATE DATABASE database_name; CREATE DATABASE database_name OWNER owner_name;

Connection limit is the maximum number of concurrent connections that a user is allowed to have against a particular redshift

Use the below command to rename a schema in Redshift where current_schema_name is the current name of the schema and

Check the current quota and disk usage of the schema by running the below query where schemaname is the name

You can view the current owner of a schema by running the below query where schema_name is the name of

Below is the sql command to rename a stored procedure where proc_name is the name of the procedure and datatype1,