Sql


        
            
        
     ALTER DATABASE target_database OWNER TO new_onwer;

ALTER DATABASE name OWNER TO new_owner;

pg_dump -Fp -f dbbackup.dmp <dbname>
vi dbbackup.dmp
:%s/oldowner/newowner/g
save and exit

PREVIOUS	NEXT

Code Example
Sql :: mysql get date diff in months
Sql :: get all tables postgres
Sql :: string to int mysql
Sql :: how to add boolean column in postgresql
Sql :: find largest table in mysql database
Sql :: show table columns mysql command line
Sql :: mysql database stopped xampp mac
Sql :: query to find table size in oracle 12c
Sql :: string to date postgres
Sql :: log queries postgre
Sql :: sql_mode=only_full_group_by
Sql :: tsql merge example
Sql :: postgres delete from where date is greater than specific date
Sql :: oracle sql drop index
Sql :: delete database mysql
Sql :: mysql get time from datetime
Sql :: get current month mysql
Sql :: dbms_scheduler stop job
Sql :: mysql server start
Sql :: add super privilege mysql
Sql :: mysql loop insert
Sql :: find column name in database
Sql :: get table column names sql ssms
Sql :: delete a view sql
Sql :: error code 1175 mysql fix
Sql :: oracle alert log location
Sql :: drop procedure sql
Sql :: Disabling foreign key checks while performing Sqlalchemy Upgrade
Sql :: role does not exist psql
Sql :: Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.