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.