<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, <div class=""><br class=""></div><div class="">I’m using the latest version of TOPCAT: V4.6-3</div><div class="">Selected the service: <a href="https://gea.esac.esa.int/tap-server/tap" class="" moz-do-not-send="true">https://gea.esac.esa.int/tap-server/tap</a></div><div class=""><div><br class=""></div><div>I saw indeed the little warning hinting to use double quotes. </div><div>It was helpful, since that’s how I learnt at first the word was reserved, and how those should be </div><div>treated. But then I wasn’t able to solve the problem with double quotes. </div><div><br class=""></div><div>Now *something* (?) might have changed between the time I wrote the first email and now, </div><div>and the exact same ADQL line is working again on that server. </div><div>I can’t send you the error message since I can’t reproduce it and I didn’t take a screen shot. </div><div><br class=""></div><div>But I see Jon has pointed out some error too, so I guess it was the same error message. </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 12:14, Mark Taylor <<a href="mailto:M.B.Taylor@bristol.ac.uk" class="">M.B.Taylor@bristol.ac.uk</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Ada,<br class=""><br class="">you don't say what service you're using, but I can only see that<br class="">table in the ESA Gaia service.<br class=""><br class="">If I run<br class=""><br class=""> select top 10 * from "public".hipparcos_newreduction<br class=""><br class="">it works fine for me. In fact even if I write<br class=""><br class=""> select top 10 * from public.hipparcos_newreduction<br class=""><br class="">the query works, though it signals a syntax error in the topcat ADQL<br class="">entry panel. In the latter case, you can use the "Sticking plaster"<br class="">button at the far right of the lower toolbar to put the quotes in<br class="">automatically (that's a fairly recent introduction, so you need a<br class="">fairly recent topcat).<br class=""><br class="">Is that the service you're using? Is the query really failing, <br class="">and if so, what's the error message?<br class=""><br class="">Mark<br class=""><br class="">On Thu, 14 Nov 2019, ada nebot wrote:<br class=""><br class=""><blockquote type="cite" class="">Hi, <br class=""><br class="">While performing a tutorial in a VO School we have seen that access through TAP using ADQL <br class="">on tables/catalogues containing the reserved word public on them was not possible. <br class="">We tried as stated in the documentation using double quotes around the word and lots of different combinations. <br class="">But that did not solve the issue. Has anyone a clue on how to do this? <br class=""><br class="">Thanks,<br class="">Ada<br class=""><br class="">Here are the queries we tried: <br class=""><br class="">SELECT TOP 10 * FROM public.hipparcos_newreduction<br class=""><br class="">SELECT TOP 10 * FROM “public”.hipparcos_newreduction<br class=""><br class="">SELECT TOP 10 * FROM “public.hipparcos_newreduction”<br class=""><br class="">SELECT TOP 10 * FROM 'public’.hipparcos_newreduction<br class="">…<br class="">SELECT TOP 10 * FROM ''public''.hipparcos_newreduction<br class="">and even something like <br class=""><br class="">SELECT TOP 10 * FROM \’public\’.hipparcos_newreduction<br class="">…<br class=""><br class=""><br class=""><br class=""></blockquote><br class="">--<br class="">Mark Taylor Astronomical Programmer Physics, Bristol University, UK<br class=""><a href="mailto:m.b.taylor@bris.ac.uk" class="">m.b.taylor@bris.ac.uk</a> +44-117-9288776 <a href="http://www.star.bris.ac.uk/~mbt/" class="">http://www.star.bris.ac.uk/~mbt/</a></div></div></blockquote></div><br class=""></div></body></html>