method

table_exists?

v4.2.7 - 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 (0)
4.2.7 (0)
4.2.9 (0)
5.0.0.1 (0)
5.1.7
5.2.3
6.0.0
6.1.3.1
6.1.7.7
7.0.0
7.1.3.2
7.1.3.4
What's this?

table_exists?(name) public

Returns true if table exists. If the schema is not specified as part of name then it will only find tables within the current schema search path (regardless of permissions to access tables in other schemas)

Show source

# File activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb, line 111
        def table_exists?(name)
          name = Utils.extract_schema_qualified_name(name.to_s)
          return false unless name.identifier

          exec_query(              SELECT COUNT(*)              FROM pg_class c              LEFT JOIN pg_namespace n ON n.oid = c.relnamespace              WHERE c.relkind IN ('r','v','m') -- (r)elation/table, (v)iew, (m)aterialized view              AND c.relname = '#{name.identifier}'              AND n.nspname = #{name.schema ? "'#{name.schema}'" : 'ANY (current_schemas(false))'}, 'SCHEMA').rows.first[0].to_i > 0
        end

table_exists?

Related methods