Re: Snippets? - Mailing list pgsql-general

From Ron
Subject Re: Snippets?
Date
Msg-id cb13d04b-2143-36f7-3f6e-f0d0979092d7@gmail.com
Whole thread Raw
In response to Snippets?  (Ken Lacrosse <klacrosse@pkwillis.com>)
List pgsql-general
On 5/24/19 1:15 PM, Ken Lacrosse wrote:

Is there any way in postgresql to have a "snippet" of SQL code which you could apply to all tables.  Something you could add which would ensure that every table always has a Created, Changed and Deleted column for example.  Sort of like a C include I suppose.  Of course if I’m building a DB schema by hand I could just copy and paste those columns but it still seems a bit too, darn humans!, error prone.


Inheritance might be what you want.

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Ken Lacrosse
Date:
Subject: Snippets?
Next
From: Adrian Klaver
Date:
Subject: Re: Snippets?