Re: create tables using the application metadata - Mailing list pgsql-admin

From Ron
Subject Re: create tables using the application metadata
Date
Msg-id 747bdd32-a2ed-2aad-9204-53b03bd8d58f@gmail.com
Whole thread Raw
In response to create tables using the application metadata  (Nikhil Ingale <niks.bgm@gmail.com>)
List pgsql-admin
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.



pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: failed to create directory in postgresql
Next
From: Teja Jakkidi
Date:
Subject: Duplicate data even with primary keys enabled