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 :: last mysql 
Sql :: mac docker mysql 
Sql :: case statement in sql 
Sql :: what is 1=2 in sql 
Sql :: sql is null or empty 
Sql :: update database collation in postgresql 
Sql :: sql server function to calculate a percentage 
Sql :: sql constraints 
Sql :: sql less than operator 
Sql :: how to compare two columns in sql server 
Sql :: what is like operator in sql 
Sql :: compare if is null sql 
Sql :: merge in sql 
Sql :: like postgres 
Sql :: sql and or 
Sql :: sqlite3.OperationalError: near "WHERE": syntax error 
Sql :: mariadb 
Sql :: casterar postgres 
Sql :: varchar2 length in oracle 
Sql :: oracle sql date winter time 
Sql :: sqlalchemy how to use sequence 
Sql :: hive hbase create external table 
Sql :: how to connect docker container to gcp sql server 
Sql :: mysql wait_timeout 
Sql :: trigger value from maltiple table to single table mysql 
Sql :: convert nvarchar to datetime sql 
Sql :: get db connection detail from sql developer profile 
Sql :: Getting error while running 50 MB script on SQL Server 
Sql :: mariadb current date plus 1 day 
Sql :: ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function 
ADD CONTENT
Topic
Content
Source link
Name
8+7 =