[Babase] Foodcodes table?
Karl O. Pinc
kop at meme.com
Fri Feb 17 12:58:53 EST 2006
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
More information about the Babase
mailing list