From 577971f05a838da3ba74ba49d776a83f6bfe1aee Mon Sep 17 00:00:00 2001
From: Travis Jeffery <travisjeffery@gmail.com>
Date: Wed, 7 Mar 2012 04:22:07 +0000
Subject: Add #schema_names to PostgreSQL Adapter.

---
 .../active_record/connection_adapters/postgresql_adapter.rb   | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'activerecord/lib/active_record/connection_adapters')

diff --git a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb
index d2126a3e19..f4efaa9b20 100644
--- a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb
+++ b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb
@@ -978,6 +978,17 @@ module ActiveRecord
         end_sql
       end
 
+      # Returns an array of schema names.
+      def schema_names
+        query(<<-SQL).flatten
+          SELECT nspname
+            FROM pg_namespace
+           WHERE nspname !~ '^pg_.*'
+             AND nspname NOT IN ('information_schema')
+           ORDER by nspname;
+        SQL
+      end
+
       # Sets the schema search path to a string of comma-separated schema names.
       # Names beginning with $ have to be quoted (e.g. $user => '$user').
       # See: http://www.postgresql.org/docs/current/static/ddl-schemas.html
-- 
cgit v1.2.3