Module: Atchu::Queries

Extended by:
Queries
Included in:
Queries
Defined in:
lib/atchu/queries.rb

Instance Method Summary collapse

Instance Method Details

#primary_key(table_name) ⇒ Object 



5
6
7
8
9
10
11
12
13
14
15
16
17
 
# File 'lib/atchu/queries.rb', line 5

def primary_key table_name
  sql = "SELECT               \n  pg_attribute.attname \nFROM pg_index, pg_class, pg_attribute \nWHERE \n  pg_class.oid = '\#{table_name}'::regclass AND\n  indrelid = pg_class.oid AND\n  pg_attribute.attrelid = pg_class.oid AND \n  pg_attribute.attnum = any(pg_index.indkey)\n  AND indisprimary\n  SQL\nend\n"