Re: create tables using the application metadata

From: Samed YILDIRIM <samed(at)reddoc(dot)net>
To: Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: create tables using the application metadata
Date: 2022-10-28 08:26:24
Message-ID: CAAo1mb=Qjs8VaoZg6-_V7bTbxknaBwA7Fs3+eRk56os9wiqvmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)bgm(at)gmail(dot)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
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Kellerer 2022-10-28 09:33:08 Re: failed to create directory in postgresql
Previous Message Samed YILDIRIM 2022-10-28 08:23:35 Re: failed to create directory in postgresql