[postgis-users] converting decimal lat/ long (GNIS) to Oregon Lambert (SRID 2992)

[Webb Sprague]

Hi all,

Is there a recipe somewhere on how to get from decimal lat/ long into
a specific SRID?  I assume that I need to go from decimal to a
geometry column in the appropriate SRID, and from that into a new
projection with transform?

(42.9, -122.1) -> some geometry -> geometry w/ SRID=2992?

I have no clue, I am embarrassed to confess

Please help!

-W