Sha256: 35baaea43632e7a234bbcb735ba51c0078c865f7526634c7c61ce2fbcc9ae46c

Contents?: true

Size: 213 Bytes

Versions: 72

Compression:

Stored size: 213 Bytes

Contents

/* Kill all the active database connections */

SELECT pg_terminate_backend(pid) FROM pg_stat_activity
  WHERE pid <> pg_backend_pid()
  AND query <> '<insufficient privilege>'
  AND datname = current_database();

Version data entries

72 entries across 72 versions & 1 rubygems

Version Path
ruby-pg-extras-5.6.1 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.6.0 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.5.1 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.5.0 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.4.5 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.4.4 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.4.3 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.4.2 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.4.1 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.4.0 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.3.1 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.3.0 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.2.5 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.2.4 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.2.3 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.2.2 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.2.1 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.2.0 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.1.0 lib/ruby_pg_extras/queries/kill_all.sql
ruby-pg-extras-5.0.0 lib/ruby_pg_extras/queries/kill_all.sql