I have an existing user called 'carlos' & I'm looking to see how how I can modify this user to be a superuser. I create that user using basic SQL commands:
CREATE USER carlos WITH PASSWORD 'booya';
I know that from the Linux shell I can use the 'createuser' script but I chose not to do so & rather trying to do this via SQL commands. I did view the documents online but couldn't find what 'option(s)' I need to add into the command. Can anyone please help me?