From 8cfb544f8ac47d56942ef76436fad067a7c2bf31 Mon Sep 17 00:00:00 2001 From: Chris Winslett Date: Mon, 12 Dec 2011 20:50:28 -0600 Subject: PostgreSQL: add extension instructions to caveats Signed-off-by: Adam Vandenberg --- Library/Formula/postgresql.rb | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'Library/Formula/postgresql.rb') diff --git a/Library/Formula/postgresql.rb b/Library/Formula/postgresql.rb index 9f57f2419..a4e41f745 100644 --- a/Library/Formula/postgresql.rb +++ b/Library/Formula/postgresql.rb @@ -124,6 +124,23 @@ Or start manually with: And stop with: pg_ctl -D #{var}/postgres stop -s -m fast +# Loading Extensions + +By default, Homebrew builds all available Contrib extensions. To see a list of all +available extensions, from the psql command line, run: + SELECT * FROM pg_available_extensions; + +To load any of the extension names, navigate to the desired database and run: + CREATE EXTENSION [extension name]; + +For instance, to load the tablefunc extension in the current database, run: + CREATE EXTENSION tablefunc; + +For more information on the CREATE EXTENSION command, see: + http://www.postgresql.org/docs/9.1/static/sql-createextension.html +For more information on extensions, see: + http://www.postgresql.org/docs/9.1/static/contrib.html + # Other Some machines may require provisioning of shared memory: -- cgit v1.2.3