[Babase] Foodcodes table?
Catherine Markham
amarkham at princeton.edu
Fri Feb 17 15:26:11 EST 2006
Hi Leah,
I'll send you the info on food codes that Daphne compiled before she
left (I'll do that to your email address in just a second). I'm not
sure how this compares to what would be on Karl's list, so wanted to
make sure you had both lists.
Catherine
Karl O. Pinc wrote:
>
> On 02/17/2006 11:25:55 AM, Leah Gerber wrote:
>
>> Karl,
>>
>> I am trying to look through a list of the valid foodcodes in Babase.
>> I can't find a support table with the foodcodes. Do you have one that
>> i could take a look at?
>
>
> This works on papio in the babase_copy database (where everything is
> at the moment.)
>
> select * from foodcodes, foodtypes
> where foodcodes.ftype = foodtypes.ftype order by fcode;
>
>
> I just took what was in the monitoring guide and coded it into
> the conversion script. (Actually I've a tab delimited text
> file, but that's awkward to look at.)
>
> (If you want text try this at the Unix prompt:
> psql -d babase_copy -c 'select * from foodcodes, foodtypes
> where foodcodes.ftype = foodtypes.ftype order by fcode;'
>
> or
> psql --pset border=0 -d babase_copy -c 'select *
> from foodcodes, foodtypes
> where foodcodes.ftype = foodtypes.ftype order by fcode;'
> )
>
> Karl <kop at meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
--
Catherine Markham
Department of Ecology and Evolutionary Biology
Princeton University
Phone: (609) 258-6898
Fax: (609) 258-2712
More information about the Babase
mailing list