Hello all:
I made a mistake. Maybe I was lazy.
I created a database and did some amount of development as postgres.
Now I need to get this changed to a log-on role say xxx-db-owner.
I have a bunch of tables , functions and user defined types.
I have created the role: xxx-db-owner.
And most important I have db backups and have a copy of the db on the server under a different name.
And I have written the sql to to the changes for the tables, functions and user defined types.