SQL Search

Search by using PostgreSQL syntax on the constraints.


Query constraints can be provided by using standard PostgreSQL syntax. Some examples:

  • targetname LIKE '%Ceres%'
  • observatory_project ILIKE 'iras'
  • reference_wavelengths_micron BETWEEN 25 AND 60
  • jpl_obj_radius > 200
  • heliocentric_distance_r < 2
  • observation_end_time - observation_start_time > 0.02 AND colour_corrected_flux_density < 20
  • targetname LIKE '%1943 XB%' AND ( obsmode = 'survey' OR obsmode ILIKE 'scan%' )


Column Name Unit Description