| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Jelte Fennema <postgres(at)jeltef(dot)nl> |
| 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-26 12:33:19 |
| Message-ID: | 36562be6-e660-4cf9-5b05-b73d5effecd0@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 2023-05-25 Th 09:23, Jelte Fennema wrote:
> 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.
Sounds promising. I'd love to see a patch.
cheers
andrew
--
Andrew Dunstan
EDB:https://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2023-05-26 13:38:51 | Re: DB migration : Sybase to Postgres |
| Previous Message | Marcos Pegoraro | 2023-05-26 10:39:04 | Re: DB migration : Sybase to Postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2023-05-26 12:48:09 | Re: running logical replication as the subscription owner |
| Previous Message | Richard Guo | 2023-05-26 10:30:06 | Re: ERROR: no relation entry for relid 6 |