| From: | Jelte Fennema <postgres(at)jeltef(dot)nl> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Kirk Wolak <wolakk(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Adding SHOW CREATE TABLE |
| Date: | 2023-05-25 13:23:40 |
| Message-ID: | CAGECzQS=_QK=RzPokZ6XeLO9yOxwiFVbGXSn+O8yRK-Gyu5saw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Mon, 22 May 2023 at 13:52, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> A performant server side set of functions would be written in C and follow the patterns in ruleutils.c.
We have lots of DDL ruleutils in our Citus codebase:
https://github.com/citusdata/citus/blob/main/src/backend/distributed/deparser/citus_ruleutils.c
I'm pretty sure we'd be happy to upstream those if that meant, we
wouldn't have to update them for every postgres release.
We also have the master_get_table_ddl_events UDF, which does what SHOW
CREATE TABLE would do.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Wienhold | 2023-05-25 13:24:17 | Re: CREATE TEMPORARY TABLE LIKE |
| Previous Message | Jim Vanns | 2023-05-25 13:19:51 | Re: CREATE TEMPORARY TABLE LIKE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vignesh C | 2023-05-25 14:23:51 | Implement generalized sub routine find_in_log for tap test |
| Previous Message | Tom Lane | 2023-05-25 13:20:32 | Re: pgindent vs. pgperltidy command-line arguments |