Packages

ecto_psql_extras

0.8.8
0.8.8 0.8.7 0.8.6 0.8.5 0.8.4 0.8.3 0.8.2 0.8.1 0.8.0 0.7.15 0.7.14 0.7.13 0.7.12 0.7.11 0.7.10 0.7.9 0.7.8 0.7.7 0.7.6 0.7.5 0.7.4 0.7.3 0.7.2 0.7.1 0.7.0 0.6.5 0.6.4 0.6.3 0.6.2 0.6.1 0.6.0 0.4.4 0.4.3 0.4.2 0.4.1 0.4.0 0.3.4 0.3.3 0.3.2 0.3.1 0.3.0 0.2.0 0.1.4 0.1.3 0.1.2 0.0.2 0.0.1

Ecto PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

HexDocs

Current section

Files

Jump to
Readme
47 Versions
3 Dependencies
Dependants
Files
Activity
ecto_psql_extras lib queries table_schema.ex
Raw

lib/queries/table_schema.ex 

defmodule EctoPSQLExtras.TableSchema do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "Column names and types",

      columns: [

        %{name: :column_name, type: :string},

        %{name: :data_type, type: :string},

        %{name: :is_nullable, type: :boolean},

        %{name: :column_default, type: :string},

        %{name: :table_name, type: :string}

      ]

    }

  end



  def query(args \\ []) do

    if args[:table_name] do

      """

      /* ECTO_PSQL_EXTRAS: Table column names and types */



      SELECT column_name, data_type, is_nullable, column_default, table_name

      FROM information_schema.columns

      WHERE table_name = '<%= table_name %>';

      """

      |> EEx.eval_string(args)

    else

      """

      /* ECTO_PSQL_EXTRAS: All database column names and types */



      SELECT column_name, data_type, is_nullable, column_default, table_name

      FROM information_schema.columns;

      """

    end

  end

end