Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

Alter owner in PostgreSQL

pg_dump -Fp -f dbbackup.dmp <dbname>
vi dbbackup.dmp
:%s/oldowner/newowner/g
save and exit
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #Alter #owner #PostgreSQL
ADD COMMENT
Topic
Name
4+6 =