I have a point and buffered it using st_buffer. How do I create a polygon geometry from that buffered point? The result of st_buffer is the polygon I need to save for future use.
I will be placing the new geometry in the geometry column of an existing table (created specifically for this purpose) and use the id of the point as the foreign key to link it back to the original point. Potentially, there may be multiple buffers for each point so point's id will not be the rows PK.
The destination table will look something like this...
CREATE TABLE geom_buffered_pts ( oid bigserial NOT NULL, point_id bigserial NOT NULL, geom geometry, CONSTRAINT geom_buffered_pts_pk PRIMARY KEY (oid) )