Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql show owner of database

SELECT d.datname as "Name",
pg_catalog.pg_get_userbyid(d.datdba) as "Owner"
FROM pg_catalog.pg_database d
WHERE d.datname = 'database_name'
ORDER BY 1;
Comment

psql owner of database

alter database database_name owner to odoo14;
Comment

PREVIOUS NEXT
Code Example
Sql :: output to file mysql 
Sql :: Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. 
Sql :: mysql find non alphanumeric characters 
Sql :: moodle query first user access 
Sql :: oracle db create new schema 
Sql :: rows to comma separated values in mssql 
Sql :: oracle view ddl 
Sql :: distincct sql 
Sql :: display total number of tables in mysql 
Sql :: mysql return if it contains 
Sql :: convert series number to date in sql 
Sql :: mysql smallint range 
Sql :: postgresql add alter permissions to role 
Sql :: select count from table mysql 
Sql :: delete table sql 
Sql :: LoadError: cannot load such file -- mysql2/2.7/mysql2 
Sql :: create sqlite database in laravel 
Sql :: get first 3 letters name in sql 
Sql :: mariadb number format 
Sql :: sysdate in sql 
Sql :: select count of distinct values sql 
Sql :: grant mysql 
Sql :: turn off safe mode mysql 
Sql :: retrieve meaning 
Sql :: mysql python 
Sql :: sysdate in oracle sql 
Sql :: mysql alter table modify column 
Sql :: simple project for database 
Sql :: clone table structure mysql 
Sql :: remove binlog mysql 
ADD CONTENT
Topic
Content
Source link
Name
8+2 =