0
$\begingroup$

I'm trying to use the SQL search at https://skyserver.sdss.org/dr18/SearchTools/sql to find (for example) QSOs with accurate redshifts from the SDSS. My query will look something like this:

SELECT TOP 100000
p.ra,p.dec,p.u,p.g,p.r,p.i,p.z,
s.specobjid, s.class, s.z as redshift
FROM PhotoObj AS p
JOIN SpecObj AS s ON s.bestobjid = p.objid
WHERE 
p.e_z < 0.01

which gives me an error "Invalid column name 'e_z'. How can I find the names of the columns? I can't find them on the SDSS website?

Improve this question
$\endgroup$
2
  • 2
    $\begingroup$ Is it the schema browser you want? skyserver.sdss.org/dr18/MoreTools/browser I found the PhotoObj view of the PhotoObjAll table, and it doesn't seem to have an e_z column $\endgroup$
    – James K
    Commented Mar 18 at 20:37
  • $\begingroup$ In SQL the „schema“ is the list of tables and their column names. And you have to consult the schema browser, that is linked from the search page, when you scroll down. $\endgroup$
    – Grimaldi
    Commented Mar 20 at 19:57

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .