How to list schemas in postgres from rails console?

Question

I would like to get a list of schemas in the current database from the rails console. Currently, I am executing raw sql to get the info via

ActiveRecord::Base.connection.execute("select schema_name from information_schema.schemata")

Is there a more correct way to retrieve this information from the rails console with ActiveRecord?

schema.rb does not contain a list of schemas. It only contains tables and columns. — sakurashinken, Jul 13 '17 at 16:32

score 7 · Answer 1 · answered Jul 14 '17 at 05:53

7

i have tried the following ,it works for me.

data = ActiveRecord::Base.connection.execute('select * from information_schema.schemata')
data.each do |schema|
  puts schema['schema_name']
end

it returns the schema names.

answered Jul 14 '17 at 05:53

chinna2580

The only difference between this answer and the question's query is that gets more stuff from the database (`*`) which it then discards. – Camille Goudeseune Aug 03 '20 at 20:41

score 3 · Accepted Answer · answered Jul 13 '17 at 02:56

3

The SQL query you used is very correct. Information schema is part of SQL standard.

ActiveRecord does not have a ready method for this.

So it seems there is no better way.

answered Jul 13 '17 at 02:56

filiprem

2 Answers2