Create PostgreSQL Role/User from within Python program

Question

Do you know if it's possible to create a role/user for the Postgresql database from within Python code?

I would prefer to use asyncpg library, since my program is based on asynchronous code, but if there are better libraries for this specific task, I don't mind using them.

I already have a pre-installed database on my server machine, so another possibility would be to just run the Shell command from withing the Python program to create a role. However, I am not sure if you can create a role in just one Shell line.

@GiovaniSalazar How would the CREATE ROLE query look like there? And do you know for sure that psycopg2 supports role creations? I couldn't find definitive answers in their docs. — TimesAndPlaces
– TimesAndPlaces, Commented Dec 10, 2019 at 17:36
psycopg2 is a client for python ...here there is an example : stackoverflow.com/questions/53022587/… — GiovaniSalazar
– GiovaniSalazar, Commented Dec 10, 2019 at 17:39
@GiovaniSalazar Thanks! I think I found an even more elegant 1-line solution to my problem: pool.execute("CREATE ROLE name ...") — TimesAndPlaces
– TimesAndPlaces, Commented Dec 10, 2019 at 17:50

TimesAndPlaces · Accepted Answer · 2019-12-10 17:50:41Z

1

After some digging, the answer appeared to be very straightforward:

pool.execute("CREATE ROLE name ...")

answered Dec 10, 2019 at 17:50

TimesAndPlaces

6201 gold badge5 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create PostgreSQL Role/User from within Python program

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related