ms2.spectradata jeckels  2009-04-27 09:37
Status: Closed
 
Hi Bill,

I'm not sure what the query would be to ask for references to the table in Postgres, but I did a quick search for "spectradata" in the MS2 module's *.sql files.

The likely reference is the ms2.Spectra views defined in ms2-create.sql:

CREATE VIEW ms2.Spectra AS
    SELECT f.Run AS Run, sd.*
    FROM ms2.SpectraData sd INNER JOIN
        ms2.Fractions f ON sd.Fraction = f.Fraction;

Thanks,
Josh