Re: How to set default owner of objects in Postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Shreeyansh Dba <shreeyansh2014@xxxxxxxxx>
Subject: Re: How to set default owner of objects in Postgresql
From: Morris de Oryx <morrisdeoryx@xxxxxxxxx>
Date: Wed, 16 Jan 2019 22:29:44 +1100
Cc: Ashif Shaikh <sashif0@xxxxxxxxx>, pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <CAGDYbUNLG-smq3G-yRqTHatoLF3=xADqg1ypbqP8KDwYTxAhDg@mail.gmail.com>
References: <CAN+GtSaUxXkwFjrp8GyJdH+F8WgOAZqz0AtoFyQR+Lghy7aR-w@mail.gmail.com> <CAGDYbUM49-=jMVyTPQGkbQhTPMLMoxU=8AxDSwu9GFk1P-1V1g@mail.gmail.com> <CAGDYbUNLG-smq3G-yRqTHatoLF3=xADqg1ypbqP8KDwYTxAhDg@mail.gmail.com>

On Wed, Jan 16, 2019 at 10:24 PM Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> wrote:

In addition, you can use an event trigger to set the default owner whenever creates the object.
https://www.postgresql.org/docs/9.6/event-trigger-definition.html

! Yet another feature I've never heard of. Pretty interesting, thanks very much for pointing it out.

References:
- How to set default owner of objects in Postgresql
  - From: Ashif Shaikh
- Re: How to set default owner of objects in Postgresql
  - From: Shreeyansh Dba
- Re: How to set default owner of objects in Postgresql
  - From: Shreeyansh Dba

Prev by Date: Re: How to set default owner of objects in Postgresql
Next by Date: extracting the domain from an email address
Previous by thread: Re: How to set default owner of objects in Postgresql
Next by thread: Re: How to set default owner of objects in Postgresql
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux