gffatts

SELECT fs.feature_id,

    'cvterm'::text AS type,

    s.name AS attribute

   FROM cvterm s,

    feature_cvterm fs

  WHERE (fs.cvterm_id = s.cvterm_id)

UNION ALL

 SELECT fs.feature_id,

    'dbxref'::text AS type,

    (((d.name)::text || ':'::text) || (s.accession)::text) AS attribute

   FROM dbxref s,

    feature_dbxref fs,

    db d

  WHERE ((fs.dbxref_id = s.dbxref_id) AND (s.db_id = d.db_id))

UNION ALL

 SELECT fs.feature_id,

    'synonym'::text AS type,

    s.name AS attribute

   FROM synonym s,

    feature_synonym fs

  WHERE (fs.synonym_id = s.synonym_id)

UNION ALL

 SELECT fp.feature_id,

    cv.name AS type,

    fp.value AS attribute

   FROM featureprop fp,

    cvterm cv

  WHERE (fp.type_id = cv.cvterm_id)

UNION ALL

 SELECT fs.feature_id,

    'pub'::text AS type,

    (((s.series_name)::text || ':'::text) || s.title) AS attribute

   FROM pub s,

    feature_pub fs

  WHERE (fs.pub_id = s.pub_id);