method

primary_keys

v5.0.0.1 - Show latest stable - 0 notes - Class: SchemaStatements

1.0.0
1.1.6
1.2.6
2.0.3
2.1.0
2.2.1
2.3.8
3.0.0
3.0.9
3.1.0
3.2.1
3.2.8
3.2.13
4.0.2
4.1.8
4.2.1
4.2.7
4.2.9
5.0.0.1 (0)
5.1.7 (0)
5.2.3 (0)
6.0.0 (0)
6.1.3.1 (0)
6.1.7.7 (0)
7.0.0 (0)
7.1.3.2 (0)
7.1.3.4 (0)
What's this?

primary_keys(table_name) public

No documentation

This method has no description. You can help the Ruby on Rails community by adding new notes.

# File activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb, line 433
        def primary_keys(table_name) # :nodoc:
          select_values(            WITH pk_constraint AS (              SELECT conrelid, unnest(conkey) AS connum FROM pg_constraint              WHERE contype = 'p'                AND conrelid = '#{quote_table_name(table_name)}'::regclass            ), cons AS (              SELECT conrelid, connum, row_number() OVER() AS rownum FROM pk_constraint            )            SELECT attr.attname FROM pg_attribute attr            INNER JOIN cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.connum            ORDER BY cons.rownum.strip_heredoc, 'SCHEMA')
        end

primary_keys

Related methods

No documentation