Postgresql equivalent to SQL Server CONTEXT_INFO

Asked Jun 24 '19 at 05:59

Active Jun 24 '19 at 06:45

Viewed 123 times

In SQL Server, there is a built-in function CONTEXT_INFO() to read the value of CONTEXT_INFO variable.

SET CONTEXT_INFO 0; // set
SELECT CONTEXT_INFO(); // Get

I want to do the same thing for PostgreSQL with Session scope. How can I do SET and GET with session scope ?

edited Jun 24 '19 at 06:45

asked Jun 24 '19 at 05:59

Pratik

2

Duplicate of [What's the PostgreSQL equivalent of MSSQL's CONTEXT\_INFO?](https://stackoverflow.com/questions/696200/whats-the-postgresql-equivalent-of-mssqls-context-info) – Kaushik Nayak Jun 24 '19 at 06:04
1

@KaushikNayak That question has no useful answers. It also doesn't address the "session scope" part. – melpomene Jun 24 '19 at 06:45
@melpomene That's true, kindly help to re-open this question by clicking on "reopen" – Pratik Jun 24 '19 at 06:48
@melpomene : Ok, I've voted to reopen. – Kaushik Nayak Jun 24 '19 at 07:34

0 Answers0