ADQL using reserved words in tables
ada nebot
ada.nebot at astro.unistra.fr
Thu Nov 14 09:17:33 CET 2019
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
…
More information about the dal
mailing list