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 Raw
In response to Re: Accessing non catalog table in backend  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Accessing non catalog table in backend  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: Accessing non catalog table in backend  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-hackers
<p dir="ltr">Thanks! <p dir="ltr">I was wary to use SPI inside the executor for node evaluation functions. Does it seem
safe?<pdir="ltr">Regards, <p dir="ltr">Atri<div class="gmail_quote">On 5 Jan 2016 12:20 am, "Jim Nasby" <<a
href="mailto:Jim.Nasby@bluetreble.com">Jim.Nasby@bluetreble.com</a>>wrote:<br type="attribution" /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 1/4/16 12:07 PM, Atri
Sharmawrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">Hi All,<br /><br /> I wanted to check if it is possible to query a non catalog table in
backend.<br/><br /> I understand that cql interface is only for catalog querying hence it is<br /> not usable for this
purposeper se.<br /></blockquote><br /> AFAIK it's possible to do it with low level routines, but I think unless you
havea really good reason to go that route you're much better off just using SPI. If it's good enough for plpgsql...
:)<br/> -- <br /> Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX<br /> Experts in Analytics, Data
Architectureand PostgreSQL<br /> Data in Trouble? Get it in Treble! <a href="http://BlueTreble.com" rel="noreferrer"
target="_blank">http://BlueTreble.com</a><br/></blockquote></div> 

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().