On 9/16/22 06:00, Marcos Pegoraro wrote:
Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> escreveu:
test(5432)=# set role maura;
ERROR: role "maura" does not exist
test(5432)=# SET SESSION AUTHORIZATION 'maura';
ERROR: role "maura" does no
On 9/16/22 19:22, Ganesh Korde wrote:
Hi,
You can use log_line_prefix in postgresql.conf to log the user name
into the logs.
That uses the session user, the user that established the connection.
What the OP is after is the role name that is set by SET ROLE or SET
SESSION AUTHORIZATION.
I should have given you the full query. Here it is
Select a.locationname, a.usercode, a.itemname, a.uomname, a.batchnumber,
a.expirydate, a.itemnamefk, a.itemuomfk, f.itemgroupname, a.locationpk,
Sum(a.quantity) as quantity, Sum(a.freequantity) as freequantity,
b.befo
On 2022-09-17 05:28:25 +, sivapostg...@yahoo.com wrote:
> My query is like this
>
> Select a.field1, a.field2, a.field3
> From (Select a.field1, b.field2, c.field3
> From table1 a
> Join table2 b
> on b.something = a.something
> Join table3 c
>
On 9/17/22 00:28, sivapostg...@yahoo.com wrote:
Hello,
My query is like this
Select a.field1, a.field2, a.field3
From (Select a.field1, b.field2, c.field3
From table1 a
Join table2 b
on b.something = a.something
Join table3 c
On c.somethin
