pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcreate tables using the application metadata
3+ messages / 3 participants
[nested] [flat]
* create tables using the application metadata
@ 2022-10-28 07:43 Nikhil Ingale <niks.bgm@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Nikhil Ingale @ 2022-10-28 07:43 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi All,
I've metadata tables of our application where we have all tables,columns
and constraints information about each table stored.
How do I generate the CREATE TABLE sql scripts to generate schema using our
application metadata table?
Regards,
Nikhil
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: create tables using the application metadata
@ 2022-10-28 08:26 Samed YILDIRIM <samed@reddoc.net>
parent: Nikhil Ingale <niks.bgm@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Samed YILDIRIM @ 2022-10-28 08:26 UTC (permalink / raw)
To: Nikhil Ingale <niks.bgm@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hello Nikhil,
Could you explain with some example data? I can't comment on it without
knowing what you have in the metadata table and its structure?
You basically can use SELECT statement and create a string through SQL
queries against to your metadata table.
Best regards.
Samed YILDIRIM
On Fri, 28 Oct 2022, 09:44 Nikhil Ingale, <niks.bgm@gmail.com> wrote:
> Hi All,
> I've metadata tables of our application where we have all tables,columns
> and constraints information about each table stored.
>
> How do I generate the CREATE TABLE sql scripts to generate schema using
> our application metadata table?
>
> Regards,
> Nikhil
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: create tables using the application metadata
@ 2022-10-28 13:40 Ron <ronljohnsonjr@gmail.com>
parent: Nikhil Ingale <niks.bgm@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ron @ 2022-10-28 13:40 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 10/28/22 02:43, Nikhil Ingale wrote:
> Hi All,
> I've metadata tables of our application where we have all tables,columns
> and constraints information about each table stored.
>
> How do I generate the CREATE TABLE sql scripts to generate schema using
> our application metadata table?
Depending on how your metadata tables are organized, use either the format()
function embedded in a SELECT statement, or have your application generate
dynamic SQL.
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-10-28 13:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-28 07:43 create tables using the application metadata Nikhil Ingale <niks.bgm@gmail.com>
2022-10-28 08:26 ` Samed YILDIRIM <samed@reddoc.net>
2022-10-28 13:40 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox