On 12 July 2018 at 02:24, Mathieu Fenniak wrote:
> I'm currently looking at a query that is generally selecting a bunch of
> simple columns from a table, and also performing some subqueries to
> aggregate related data, and then sorting by one of the simple columns and
> paginating the result.
>
>
Hi
I am quite happy to announce the first release package of pglogger for
structured logging to table and/or standard out. I crafted it inspired
by log4j in the hope I could give back the community a bit. You find
details at https://sourceforge.net/p/pglogger/wiki/Home/
Kind regards
Thiemo
Hello Jacek
From: Łukasz Jarych [mailto:jarys...@gmail.com]
Sent: Samstag, 14. Juli 2018 11:55
To: clavadetsc...@swisspug.org; pgsql-gene...@postgresql.org >> PG-General
Mailing List
Subject: Re: Read only to schema
Thank you very much Charles!
Awesome knowledge, thank you!
I
Thank you very much Charles!
Awesome knowledge, thank you!
I will test it and let you know if it is working like a charm (i am on
vacation now and without access to postgresql).
I am wondering with one thing:
GRANT CREATE ON SCHEMA PUBLIC TO jaryszek;
This will allow to create, drop, isnert
An addition to my previous post (marked as [addition]).
From: Charles Clavadetscher [mailto:clavadetsc...@swisspug.org]
Sent: Samstag, 14. Juli 2018 08:23
To: 'Łukasz Jarych' ; pgsql-gene...@postgresql.org
Subject: RE: Read only to schema
Hello
From: Łukasz Jarych
Hello
From: Łukasz Jarych [mailto:jarys...@gmail.com]
Sent: Freitag, 13. Juli 2018 16:39
To: pgsql-gene...@postgresql.org >> PG-General Mailing List
Subject: Re: Read only to schema
I found something like this:
CREATE ROLE readonly_user
WITH LOGIN
ENCRYPTED PASSWORD