alter_extension(7)

ALTER EXTENSION \nname\n UPDATE [ TO \nnew_version\n ]
ALTER EXTENSION \nname\n SET SCHEMA \nnew_schema\n
ALTER EXTENSION \nname\n ADD \nmember_object\n
ALTER EXTENSION \nname\n DROP \nmember_object\n
where \nmember_object\n is:
\n
  ACCESS METHOD \nobject_name\n |
\n
  AGGREGATE \naggregate_name\n ( \naggregate_signature\n ) |
\n
  CAST (\nsource_type\n AS \ntarget_type\n) |
\n
  COLLATION \nobject_name\n |
\n
  CONVERSION \nobject_name\n |
\n
  DOMAIN \nobject_name\n |
\n
  EVENT TRIGGER \nobject_name\n |
\n
  FOREIGN DATA WRAPPER \nobject_name\n |
\n
  FOREIGN TABLE \nobject_name\n |
\n
  FUNCTION \nfunction_name\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ] |
\n
  MATERIALIZED VIEW \nobject_name\n |
\n
  OPERATOR \noperator_name\n (\nleft_type\n, \nright_type\n) |
\n
  OPERATOR CLASS \nobject_name\n USING \nindex_method\n |
\n
  OPERATOR FAMILY \nobject_name\n USING \nindex_method\n |
\n
  [ PROCEDURAL ] LANGUAGE \nobject_name\n |
\n
  PROCEDURE \nprocedure_name\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ] |
\n
  ROUTINE \nroutine_name\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ] |
\n
  SCHEMA \nobject_name\n |
\n
  SEQUENCE \nobject_name\n |
\n
  SERVER \nobject_name\n |
\n
  TABLE \nobject_name\n |
\n
  TEXT SEARCH CONFIGURATION \nobject_name\n |
\n
  TEXT SEARCH DICTIONARY \nobject_name\n |
\n
  TEXT SEARCH PARSER \nobject_name\n |
\n
  TEXT SEARCH TEMPLATE \nobject_name\n |
\n
  TRANSFORM FOR \ntype_name\n LANGUAGE \nlang_name\n |
\n
  TYPE \nobject_name\n |
\n
  VIEW \nobject_name\n
and \naggregate_signature\n is:
* |
[ \nargmode\n ] [ \nargname\n ] \nargtype\n [ , ... ] |
[ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [ , ... ] ] ORDER BY [ \nargmode\n ] [ \nargname\n ] \nargtype\n [ , ... ]

ALTER EXTENSION hstore UPDATE TO '2.0';

ALTER EXTENSION hstore SET SCHEMA utils;

ALTER EXTENSION hstore ADD FUNCTION populate_record(anyelement, hstore);