Horton

Re: [PATCH] Add pg_get_role_ddl() functions for role recreation

Quan Zongliang <quanzongliang@yeah.net>

View thread
From: Quan Zongliang <quanzongliang@yeah.net>
To: Bryan Green <dbryan.green@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-11-07T03:36:33Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add infrastructure for pg_get_*_ddl functions

  2. Add pg_get_role_ddl() function


On 11/7/25 12:20 AM, Bryan Green wrote:

>>
> The rebased patch is attached.
> 
> Thanks,
> 
Currently, we have the "CREATE USER" command. Should we consider 
outputting users with the "LOGIN" attribute as "CREATE USER"?
Otherwise, it might look a little strange.

postgres=# CREATE USER testuser;
CREATE ROLE
postgres=# SELECT pg_get_role_ddl('testuser');
                                           pg_get_role_ddl
---------------------------------------------------------------------------------------------------
  CREATE ROLE testuser LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT 
NOREPLICATION NOBYPASSRLS;
(1 row)

The drawback of doing this is that the command "CREATE ROLE xxx LOGIN" 
will be converted to "CREATE USER". But I still think this is better.

Regards,

--
Quan Zongliang