Class: ActiveRecord::ConnectionAdapters::PostgreSQLAdapter

Inherits:
AbstractAdapter
  • Object
show all
Defined in:
lib/standard_api/active_record/connection_adapters/postgresql/schema_statements.rb

Instance Method Summary collapse

Instance Method Details

#database_comment(database_name = nil) ⇒ Object

Returns a comment stored in database for given table



6
7
8
9
10
11
12
13
14
15
16
17
 
# File 'lib/standard_api/active_record/connection_adapters/postgresql/schema_statements.rb', line 6

def database_comment(database_name=nil) # :nodoc:
  database_name ||= current_database

  scope = quoted_scope(database_name, type: "BASE TABLE")
  if scope[:name]
    query_value(<<~SQL, "SCHEMA")
      SELECT pg_catalog.shobj_description(d.oid, 'pg_database')
      FROM   pg_catalog.pg_database d
      WHERE  datname = #{scope[:name]};
    SQL
  end
end