Needed to create circles of varying radii from point-distance data in PostGIS table

Create "circles" in PostGIS for QGIS

# Assumptions:
#  1.  You have a table (sample) with a Geography column (loc).
#  2.  That column contains only points (not a hard reqmt).
#  3.  You have a double precision column representing radius.
#  4.  That radius is in METERS (otherwise need to convert something somewhere).

# Found it easiest to create a new table rather than
# a view for use within QGIS.
CREATE TABLE sample_buffers AS 
  SELECT ST_Buffer(sample.loc,sample.radius_meters)
  FROM sample;

# More clarity for me to rename the column here than in 
# the query above.
ALTER TABLE sample_buffers RENAME COLUMN st_buffer TO my_circles;

# Make the sole column the primary key (req'd for QGIS)
ALTER TABLE sample_buffers ADD PRIMARY KEY (my_circles);

# Now just add a PostGIS layer as normal to QGIS pointing at sample_buffers