<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Gregory, <div class=""><br class=""></div><div class="">Yes I have tried the ASCII double quotes (my email converted those into funny characters). </div><div class=""><div>It doesn’t work - at least not from TOPCAT. </div><div><br class=""></div><div>Cheers,</div><div>Ada</div><div><br class=""><blockquote type="cite" class=""><div class="">On 14 Nov 2019, at 09:56, Gregory MANTELET <<a href="mailto:gregory.mantelet@astro.unistra.fr" class="">gregory.mantelet@astro.unistra.fr</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" class="">
<div text="#000000" bgcolor="#FFFFFF" class="">
Hi Ada,<br class="">
<br class="">
Indeed `public` is a reserved keyword and it should not be allowed
to write it as such. You need to use double quotes.<br class="">
I see in yours queries that you used funny double quote
characters.....have you tried the normal ASCII ones?<br class="">
The query would look like this:<br class="">
<br class="">
<blockquote class="">
<pre class="moz-quote-pre" wrap="">SELECT TOP 10 * FROM "public".hipparcos_newreduction</pre>
</blockquote>
Cheers,<br class="">
Grégory<br class="">
<br class="">
<br class="">
<div class="moz-cite-prefix">On 14/11/2019 09:17, ada nebot wrote:<br class="">
</div>
<blockquote type="cite" cite="mid:62C17F98-67C1-4A36-B660-6EE80D9D50DA@astro.unistra.fr" class="">
<pre class="moz-quote-pre" wrap="">Hi,
While performing a tutorial in a VO School we have seen that access through TAP using ADQL
on tables/catalogues containing the reserved word public on them was not possible.
We tried as stated in the documentation using double quotes around the word and lots of different combinations.
But that did not solve the issue. Has anyone a clue on how to do this?
Thanks,
Ada
Here are the queries we tried:
SELECT TOP 10 * FROM public.hipparcos_newreduction
SELECT TOP 10 * FROM “public”.hipparcos_newreduction
SELECT TOP 10 * FROM “public.hipparcos_newreduction”
SELECT TOP 10 * FROM 'public’.hipparcos_newreduction
…
SELECT TOP 10 * FROM ''public''.hipparcos_newreduction
and even something like
SELECT TOP 10 * FROM \’public\’.hipparcos_newreduction
…
</pre>
</blockquote>
<br class="">
</div>
</div></blockquote></div><br class=""></div></body></html>