Re: Snippets?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Snippets?
Date: 2019-05-24 18:20:37
Message-ID: cb13d04b-2143-36f7-3f6e-f0d0979092d7@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

  • Snippets? at 2019-05-24 18:15:09 from Ken Lacrosse

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-05-24 18:27:08 Re: Snippets?
Previous Message Ken Lacrosse 2019-05-24 18:15:09 Snippets?