Re: Account privileges

2021-11-17 Thread Prathima Mulpuri
Thank you for your suggestions. I want to use pg_cron extension to schedule the weekly job to capture the privileges of all the databases. I cannot use node.js as it needs to connect from an EC2 to make the connection. I have do do everything inside the RDS only. Sent from my iPhone > On 17

Re: Postgres Equivalent of Oracle Package

2021-11-17 Thread Mladen Gogala
On 11/16/21 12:23, DAVID ROTH wrote: One of the nice things about Oracle packages is that the code is loaded and global values are set and stored only once per session. This is very useful for values that are used repeatedly. What is the best way of emulating this behavior in Postgresql?

Re: postgresql 9.6x installers for windows are no longer available

2021-11-17 Thread Adrian Klaver
On 11/16/21 21:44, Ryan Wexler wrote: Does anyone know what happened to the EDB windows postgresql 9.6 installers? See this post: https://www.postgresql.org/message-id/CA%2BOCxowLNQeJ-%2BHKCnsQFgAjX642oociM-wq5t%3Dar%2BDdc2m24g%40mail.gmail.com -- Adrian Klaver adrian.kla...@aklaver.com

Re: postgresql 9.6x installers for windows are no longer available

2021-11-17 Thread Adrian Klaver
On 11/16/21 21:44, Ryan Wexler wrote: Does anyone know what happened to the EDB windows postgresql 9.6 installers? FYI, I also brought this up on the -www list. The host skips from 9.5->10 https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Re: How is JSON stored in PG ?

2021-11-17 Thread Laurenz Albe
On Tue, 2021-11-16 at 10:54 -0500, David Gauthier wrote: > Hi: > > psql (11.5, server 11.3) on linux > > I'm considering using JSON as a datatype for something I'm working on.  The > reasons are... > > 1) the 'metadata' (if you want to call it that) in JSON is very flexible.  > Doesn't require

Re: Account privileges

2021-11-17 Thread Joe Conway
On 11/16/21 9:07 PM, Prathima Mulpuri wrote: Hi all, I need some help regarding Postgres and I have checked and tried many queries. I am working on RDS Postgres 13 and in the process of preparing the script for auditing all the user privileges . As a part of our auditing, I need a script to list

postgresql 9.6x installers for windows are no longer available

2021-11-17 Thread Ryan Wexler
Does anyone know what happened to the EDB windows postgresql 9.6 installers? The host skips from 9.5->10 https://www.enterprisedb.com/downloads/postgres-postgresql-downloads