[postgis-users] Polygon from point query

[Poynter, David]

This is probably an easy one, but being a PostGIS newb I've been spinning my wheels and haven't the google fu to locate an answer, so here goes...

I have a table of counties from the state (county) and I'm creating a point to insert in another table and I would like to find the county the point falls in.
I think I should be able to do it in one query rather than looping thru county by county, but I can't seem to put it together.

SELECT county_nam FROM county WHERE ?

I've been looking at ST_Within() and think the answer lies with it somehow, thanks for any clues...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101228/c7916511/attachment.html>