Hi Nishant On 04/11/2025 11:37, Nishant Sharma wrote: > Using name as parameter is more user friendly than OID. > Because users usually do not know the oids. Constructing > the DDL from the name appears better as it contains a name > in it. So, no gain in having an OID version of > pg_get_tablespace_ddl.
Would you also say that having a pg_tablespace_size(oid) has no benefit? I took a look at similar functions, and the only pattern I could identify is that all of them take an oid parameter. pg_tablespace_size: oid and name pg_tablespace_location: oid has_tablespace_privilege: oid, name, and text pg_tablespace_databases: oid ... pg_get_tablespace_ddl: name I'm definitely not opposed to having just a name parameter, but I thought it would be worth mentioning. Best, Jim
