Request a Demo
Home   >   mailing lists

Re: Accessing non catalog table in backend - Mailing list pgsql-hackers

From Atri Sharma
Subject Re: Accessing non catalog table in backend
Date
Msg-id CAOeZVic=k78Ex8qwrro+MuAos3fbaQ3nZxvC7RUyH9ir9ESwVQ@mail.gmail.com
Whole thread
In response to Re: Accessing non catalog table in backend  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Accessing non catalog table in backend
Re: Accessing non catalog table in backend
List pgsql-hackers
Tree view

Thanks!

I was wary to use SPI inside the executor for node evaluation functions. Does it seem safe?

Regards,

Atri

On 5 Jan 2016 12:20 am, "Jim Nasby" <Jim.Nasby@bluetreble.com> wrote:
On 1/4/16 12:07 PM, Atri Sharma wrote:
Hi All,

I wanted to check if it is possible to query a non catalog table in backend.

I understand that cql interface is only for catalog querying hence it is
not usable for this purpose per se.

AFAIK it's possible to do it with low level routines, but I think unless you have a really good reason to go that route you're much better off just using SPI. If it's good enough for plpgsql... :)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Accessing non catalog table in backend
Next
From: Greg Stark
Date:
Subject: Re: pgsql: Further tweaking of print_aligned_vertical().