Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vLg2J-006qYM-2t for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Nov 2025 11:07:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vLg2I-00COXo-1R for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Nov 2025 11:07:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vLg2I-00COXe-0U for pgsql-hackers@lists.postgresql.org; Wed, 19 Nov 2025 11:07:42 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vLg2F-000KHG-27 for pgsql-hackers@postgresql.org; Wed, 19 Nov 2025 11:07:41 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-640bd9039fbso11112072a12.2 for ; Wed, 19 Nov 2025 03:07:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1763550459; x=1764155259; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=+QouIYsEmkQm2MfBoEKVRvNVHwoxLTh+PVf0E97dy1M=; b=CTd/UfZgmxO6PwEQoE3xKzwMqmDZxbi2oCQxS9DWYZgy1DYEMDl/n2AyGFg/9YioVN BAzxpivNfVmRrmNzRUYZ7mvdU4dHBUB+vHWqrC7wTDGT7aFfjpHm8IN5U5UU1pVCGx3i ya8TQDY+dc/rGdEyhIZn66E3FttPGD1HCNxVAShggOMr3UaBcpn4fW7hH6AKCpJHNSl7 wwaAVWjWqRLh3FzsAMTiGBysRmvsGyMr03c23JdVOYjXU+hfkyG2nAouC/6cOKh/nA3K 9fHj/Vau+sOhbpwknefKYMI1u2lHS5WOWqdv34YbmGjMMD4vyH6M21TRnysjmBn/zXQQ nVTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763550459; x=1764155259; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=+QouIYsEmkQm2MfBoEKVRvNVHwoxLTh+PVf0E97dy1M=; b=Mn6j0DLWRqCMFfI7ldYlZVVWHilKazVHbi+X73gGn6rbkGvx6b/1KN+V9xKov+uCD/ RKTH9gnh1rifrXLPeOT4IyFeU9ctCRY3+ExtJL+1PddsfsjpXtUdLY4Zk0jC9bAxF8Nk L96wch/c4eTWrHOz59Jy9Z072bcxZKRkpgv9MLWlQl8QRLQ7bVqhtdw1Nfg2VAZOUBtC B4fFixfGWvzk8p9OwntrGsTbYahNKTk8QQyhl4IFaqOc0OKQllz+gSZr8uc0AUIDLGaX VPELYDErKFThIAm8RhJ5aBCnuA4OjQwr4Rj36B9q/2A0vMcK7KeIbKzGYLvKLKzx5/Q6 Zccw== X-Forwarded-Encrypted: i=1; AJvYcCWO2OBxe2/aIwVvRTk1ArHLYrc68ML3o6YC9TJS88C+Du/N8W2q7WyuPTLKE6x9h/5K8NNzBNhGVanyKjBU@postgresql.org X-Gm-Message-State: AOJu0Yyya+nVMtXJZGEQFP7offNP9miwMb2Iq3md+FYStUFGpmkmp2of j+jzk8kR0mf+dqZqw/LWXbzuDB+JAg0sAUvzYj1HwikqP+NyN0DFq7A1EEE4GjLJjwLKnJfMHIO rhakV3ueh54TBqCdy9j5MONJR5I3V/eQY7Ei3GFx3 X-Gm-Gg: ASbGncu3YatV+AogzzGC4VmeBBGh3DQRcMxODDvtm8rse4R3nKrCyZ9fOE22Tdz0wls WlNaq4ZAHMNZSBaOW+xavRo+U+FdXt0HYpEoomwtKYJGhyER3tWo6noUtdS9bA5xvq76dL+QEm6 OE6U9OnpSnkTqXOi/lKOqw41Ih6Z/QOhWVteZAU4yOoBBrHkmPFKwqbIAUGZK6+L3iOPtWRVJGK n5KknhmDiFumn9nxLo63kMbhweqUGlQAH/dA/Pe1iM1I0w0qHWvJvP+s/krnLX+fy7YARD35loj Qdl85BIp X-Google-Smtp-Source: AGHT+IHctssHHLC08ABuGM5zZUGctDdBJqbFyIspXjXH2RbhY0claXGQFJlhlsK4vcy00I44TxHGidQsuL9hkwLJY7A= X-Received: by 2002:a17:907:3e9f:b0:b73:6495:fa91 with SMTP id a640c23a62f3a-b763786a271mr236822066b.16.1763550458807; Wed, 19 Nov 2025 03:07:38 -0800 (PST) MIME-Version: 1.0 References: <202511191045.tckydhpoxumx@alvherre.pgsql> In-Reply-To: <202511191045.tckydhpoxumx@alvherre.pgsql> From: Akshay Joshi Date: Wed, 19 Nov 2025 16:37:27 +0530 X-Gm-Features: AWmQ_bm4v70nYqcBTYbmBG3e1-Z75EmVVmR9TnaqKYmYgmX09TU6wBR4HMoLoIw Message-ID: Subject: Re: [PATCH] Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement To: =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: Chao Li , Japin Li , Quan Zongliang , pgsql-hackers Content-Type: multipart/alternative; boundary="000000000000a41a4c0643f096bd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a41a4c0643f096bd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks =C3=81lvaro Will work on it and send the updated patch. On Wed, Nov 19, 2025 at 4:17=E2=80=AFPM =C3=81lvaro Herrera wrote: > Hello, > > One thing I realized a few days ago is that since commit bd09f024a1bb we > have type regdatabase, so instead of having two functions (one taking > name and one taking Oid), we should have just one, taking regdatabase, > just like the functions for producing DDL for other object types that > have corresponding reg* type. > > Regards, > > -- > =C3=81lvaro Herrera PostgreSQL Developer =E2=80=94 > https://www.EnterpriseDB.com/ > --000000000000a41a4c0643f096bd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks=C2=A0=C3=81lvaro
Will work on it and send the up= dated patch.

On Wed, Nov 19, 2025 at 4:17=E2=80=AFPM = =C3=81lvaro Herrera <alvherre@ku= rilemu.de> wrote:
Hello,

One thing I realized a few days ago is that since commit bd09f024a1bb we have type regdatabase, so instead of having two functions (one taking
name and one taking Oid), we should have just one, taking regdatabase,
just like the functions for producing DDL for other object types that
have corresponding reg* type.

Regards,

--
=C3=81lvaro Herrera=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0PostgreSQL Developer= =C2=A0 =E2=80=94=C2=A0 https://www.EnterpriseDB.com/
--000000000000a41a4c0643f096bd--