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("      SELECT pg_catalog.shobj_description(d.oid, 'pg_database')\n      FROM   pg_catalog.pg_database d\n      WHERE  datname = \#{scope[:name]};\n    SQL\n  end\nend\n", "SCHEMA")