Re: Accessing non catalog table in backend

<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>