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 1wXPm9-003FX4-1G for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Jun 2026 20:43:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wXPm8-00Cz8H-0q for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Jun 2026 20:43:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wXPm7-00Cz88-2z for pgsql-hackers@lists.postgresql.org; Wed, 10 Jun 2026 20:43:47 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wXPm5-00000002Ofg-2G5B for pgsql-hackers@lists.postgresql.org; Wed, 10 Jun 2026 20:43:47 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-7dfceeaf168so68910387b3.0 for ; Wed, 10 Jun 2026 13:43:45 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781124224; cv=none; d=google.com; s=arc-20240605; b=JNYrMA3y3jOxman8F9g6wtULNgCqHJtvwDCKKWM1b7eocDu6aOSmd+vtMiMOHYIeRh 5M/clg7zmrgljRtxs0j6HPgPygxrBauDRjdvBuachqRyNY5mpVVeQmmAcARqOp5LUj6Z 4eHv2RBKz0eTiKDADTBac1pteEgaLree3nxFkk4MBfI7MDkO+HnqghXlv+wYCxFBVSPk cvBnKe876/OJcs8rk3dFCmGpTrQSRNCJNwk3+fTXu6ANnvChDpgPMPkQv0AdeILm7F6P ptUFrxAGwsmlDluQ0mzVDBq2X8GygOGWTgmI51UsO8RFxhQedT+nQP/9bNfPBUbJTEZW 73Dg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :dkim-signature; bh=WYukWHtFFM+X8SObosYuftgjeIAHdKZvrevhvnlXhmQ=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=ZpObF9WoBg2PkpdPUMGpoNxoYQEIgv/dNIF26QUbCRBbx2Wi3mJgz7zk2DAfqB33Y6 leGn6LcnS7aSWroTG2jYNjqDVzTerpBWyy3j9n5J2g2YV8GbcdJ17Jofnk2CdOi33SWX jybVfWd05URExvd5hCEmSfXg0TPMDqktPFU00e3HjX35IRR2ixWSIhbuGKoRekB1dKSp DavjJKc8lf64YR+tBpscRY8dMJLTddazFQzjzLHmlXBd5ChM8PvOsLLspDPMBySxb+Cz Aw6jDFynBRtvKybOByZ/pMwKbT3zcBG7ly/pqChf9lUlugete+CBbFeoOAfPV8WJ7EDI 6K1A==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=percona.com; s=google; t=1781124224; x=1781729024; darn=lists.postgresql.org; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :from:to:cc:subject:date:message-id:reply-to; bh=WYukWHtFFM+X8SObosYuftgjeIAHdKZvrevhvnlXhmQ=; b=izNvKt6LDdY2fSedxRsxxIIpL0z7A7BYKzYkZVDiJjGz4itQM0/UIkemu9Qp8ZWHuy jmF2K/VmxHzIzMLxDkmwWVPG9QQmPN6TI3SAot0QXglt3BBKghzrGa/vEmzUV9PLF+KW sYYd8K2omLLnDe1Wvb/c7TTeiLo2G+8h4Ph3t6hig12PHQfUcGS9b7zrjLkKsSIKdWt7 Cmq8u26FdFFy6KybRIJMR8V2ElRPwnWWvoF14o7wunAQiAQSqBJGKzxt1t8Am2e92wBG fje+rB+0V2e1Ip2DuDsJvBuPX7Su59I5QElKU1ufBZN91VW3muCqDNajsuhNcM7TJLZr U1IA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781124224; x=1781729024; h=to:subject:message-id:date:mime-version:references:in-reply-to:from :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=WYukWHtFFM+X8SObosYuftgjeIAHdKZvrevhvnlXhmQ=; b=B5aFHmOk3WX1mWvoV6xZkgVRqWVkLHsuPGpyuOJqzllPiLtRt26nVTl4LAXx2mNq6d +AB/NjXLh8KndA4TsLIra/21huzPoNewpShA91HxWiWjaMrb/x+AbrypGP8eXd1HTt72 zg/kh7BEkAmb19hRNWpSBnkOEztzqyiq+Gg3nCIKRUZPWnjlsQFlW5KwB9zQKHHqPtnv RKKyaQgEtNiw9/904dyqxsfOr7zmNRrG3rXe5QNT7DtNDrzvddAx1ZO9m8aOte4N4uPK gdh2d0OkijEU+scvFSDDbPdXMtQcKf+iKUt7c6+gw+edjBBnhmguO1mKtZLD5J9y6t+h 9A4A== X-Gm-Message-State: AOJu0YykZXvE1ru5rWNb9/ie+DsKYeObPJ/HTxDh3qcghGJmB0PkNWSb JgrIMbRQ8VwPw9ZtGm3YcR+DPgRdFwq44VZXef6CPi4uZBJnrEAb24kHfuqPEHWTkaGd9n5Y6Qc GDo1FjPgqd0rCanptHHgMsNUDi9EwjnEa2m5uucVy6tnS2PEJg7p4A8fRo8xJ3ObGJFjGjLuQ22 U2SVdtpHpDSY3i46dTZm8O9CC78y7E00F5EqND/7ZbVibIlwnhgW1snWx1n/WnxFO+tfFmVedNb s1Pk8fZqdkIL3vW0jJ7CiouWjJEl+QAqfAaBpZoo9Nz2lKRRgt1SWBlFNor9ovziFno+VzDaCMJ RA== X-Gm-Gg: Acq92OGC5b6+KpNBfXr5ggq1whvOeHWqkEAiy0FMoiRzFSvqJFzEabRRb+jToaYaBkC M/q9zNsxnPZD1eQRpaHC0UzCeUfn10MTMABK5Eh9RQWsZUDzexSjb+i6L1DADyW04F7V4t6d1Fs vpfEEcIDkIBrxkVi36ViTsPOghOlGpxKt91EzoGPfe4nAEM9Uv0S2CA4VPt6/Pm+wO30IjyQwYM 1qelczBDW/eGrzGBeZxX8MwPdMSRHNVpHUypDWYi5zaRNRy1F06KYuhNtVidMeFDw60I+A3/BQX CQgkUPt5KjH65j3MkP8N3u+2qH96SAnMZcJDhXKUaw1mCR0amyFeqVZl1Wqf2VsNO1wGHz+pBrt Bx5U= X-Received: by 2002:a05:690c:e34c:b0:7db:ccda:a409 with SMTP id 00721157ae682-7f616f1f7a5mr11416097b3.9.1781124223482; Wed, 10 Jun 2026 13:43:43 -0700 (PDT) Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 10 Jun 2026 15:43:41 -0500 Received: from 298783833264 named unknown by gmailapi.google.com with HTTPREST; Wed, 10 Jun 2026 15:43:41 -0500 From: Zsolt Parragi In-Reply-To: References: MIME-Version: 1.0 Date: Wed, 10 Jun 2026 15:43:41 -0500 X-Gm-Features: AVVi8CcQBthQuZbRj1xnr0jSVRFYj_Fvwmn6P8kgbxnycUtEs7GcRRojBKjHA_I Message-ID: Subject: Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements To: pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Thanks for the update! The new version looks mostly good, I only found one corner case that doesn't work, double quoted literals can still get over-stripped: CREATE SCHEMA s; CREATE TABLE s.p (id int, "s.weird" int) PARTITION BY RANGE (id); CREATE TABLE s.pc PARTITION OF s.p (CONSTRAINT chk CHECK ("s.weird" > 0)) FOR VALUES FROM (0) TO (100); SELECT * FROM pg_get_table_ddl('s.pc', 'owner', 'false', 'schema_qualified', 'false');