Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXi3f-0005Cy-99 for pgsql-general@arkaria.postgresql.org; Thu, 02 Mar 2023 12:29:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pXi3d-0001EK-Lk for pgsql-general@arkaria.postgresql.org; Thu, 02 Mar 2023 12:29:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXi3d-0001E8-A5 for pgsql-general@lists.postgresql.org; Thu, 02 Mar 2023 12:29:13 +0000 Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXi3W-0000pb-KQ for pgsql-general@lists.postgresql.org; Thu, 02 Mar 2023 12:29:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com; s=20170201; h=In-Reply-To:Content-Type:MIME-Version:References:Reply-To: Message-ID:Subject:Cc:To:Sender:From:Date:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=z73M5TCCX+E3I6qR+tpIeznPbZNrWaPLRlI74YCi5JA=; b=KqvPUMHdyARFst6UBApyBqn2n9 I/dkefzu7XDnTj5m2cdVsb2rRb8QjTPvX1Mv0Fa8/vFfie6E+ah1t8X3PsE0KLE0Woui5xBeQxD6M geZKpZ3WbAsiZQweJNIntbUCY4qFXVpk+mdSKqVvkJREcvshK6WyQzCkmt2ezUhOnPGY=; Received: from depesz by depesz.com with local (Exim 4.94.2) (envelope-from ) id 1pXi3S-003huu-Jw; Thu, 02 Mar 2023 13:29:02 +0100 Date: Thu, 2 Mar 2023 13:29:02 +0100 From: hubert depesz lubaczewski Sender: depesz@depesz.com To: Joe Wildish Cc: pgsql-general@lists.postgresql.org Subject: Re: Getting the exact SQL from inside an event trigger Message-ID: Reply-To: depesz@depesz.com References: <10164c95-ef23-4624-9251-ea6ff594cd1c@app.fastmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <10164c95-ef23-4624-9251-ea6ff594cd1c@app.fastmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Mar 02, 2023 at 11:12:37AM +0000, Joe Wildish wrote: > We are using event triggers to capture DDL for subsequent replay on a logical replica. This might be a bit different answer from what you expect, but have you seen pgl_ddl_deploy project? Best regards, depesz