Module Sequel::Postgres
In: lib/sequel/extensions/pg_range_ops.rb
lib/sequel/extensions/pg_array_ops.rb
lib/sequel/extensions/pg_inet.rb
lib/sequel/extensions/pg_row_ops.rb
lib/sequel/extensions/pg_range.rb
lib/sequel/extensions/pg_row.rb
lib/sequel/extensions/pg_array.rb
lib/sequel/extensions/pg_inet_ops.rb
lib/sequel/extensions/pg_hstore_ops.rb
lib/sequel/extensions/pg_enum.rb
lib/sequel/extensions/pg_interval.rb
lib/sequel/extensions/pg_hstore.rb
lib/sequel/extensions/pg_loose_count.rb
lib/sequel/extensions/pg_json_ops.rb
lib/sequel/extensions/pg_static_cache_updater.rb
lib/sequel/extensions/pg_json.rb
lib/sequel/adapters/postgres.rb
lib/sequel/adapters/shared/postgres.rb

Top level module for holding all PostgreSQL-related modules and classes for Sequel. All adapters that connect to PostgreSQL support the following options:

:client_min_messages :Change the minimum level of messages that PostgreSQL will send to the the client. The PostgreSQL default is NOTICE, the Sequel default is WARNING. Set to nil to not change the server default. Overridable on a per instance basis via the :client_min_messages option.
:force_standard_strings :Set to false to not force the use of standard strings. Overridable on a per instance basis via the :force_standard_strings option.
:search_path :Set the schema search_path for this Database‘s connections. Allows to to set which schemas do not need explicit qualification, and in which order to check the schemas when an unqualified object is referenced.

Methods

Classes and Modules

Module Sequel::Postgres::ArrayOpMethods
Module Sequel::Postgres::EnumDatabaseMethods
Module Sequel::Postgres::HStoreOpMethods
Module Sequel::Postgres::InetDatabaseMethods
Module Sequel::Postgres::InetDatasetMethods
Module Sequel::Postgres::InetOpMethods
Module Sequel::Postgres::IntervalDatabaseMethods
Module Sequel::Postgres::IntervalDatasetMethods
Module Sequel::Postgres::JSONDatabaseMethods
Module Sequel::Postgres::JSONOpMethods
Module Sequel::Postgres::LooseCount
Module Sequel::Postgres::PGRow
Module Sequel::Postgres::RangeOpMethods
Module Sequel::Postgres::StaticCacheUpdater
Class Sequel::Postgres::Adapter
Class Sequel::Postgres::ArrayOp
Class Sequel::Postgres::Database
Class Sequel::Postgres::Dataset
Class Sequel::Postgres::HStore
Class Sequel::Postgres::HStoreOp
Class Sequel::Postgres::InetOp
Class Sequel::Postgres::JSONArray
Class Sequel::Postgres::JSONArrayBase
Class Sequel::Postgres::JSONBArray
Class Sequel::Postgres::JSONBHash
Class Sequel::Postgres::JSONBOp
Class Sequel::Postgres::JSONBaseOp
Class Sequel::Postgres::JSONHash
Class Sequel::Postgres::JSONHashBase
Class Sequel::Postgres::JSONOp
Class Sequel::Postgres::PGArray
Class Sequel::Postgres::PGRange
Class Sequel::Postgres::PGRowOp
Class Sequel::Postgres::RangeOp

Constants

NAN = 0.0/0.0
PLUS_INFINITY = 1.0/0.0
MINUS_INFINITY = -1.0/0.0
TYPE_TRANSLATOR = tt = Class.new do def boolean(s) s == 't' end

Public Class methods

Whether the given sequel_pg version integer is supported.

[Source]

    # File lib/sequel/adapters/postgres.rb, line 31
31:       def self.sequel_pg_version_supported?(version)
32:         version >= 10617
33:       end

Public Instance methods

[Source]

    # File lib/sequel/adapters/shared/postgres.rb, line 42
42:       def bytea(str)
43:         str = if str =~ /\A\\x/
44:           # PostgreSQL 9.0+ bytea hex format
45:           str[2..-1].gsub(/(..)/){|s| s.to_i(16).chr}
46:         else
47:           # Historical PostgreSQL bytea escape format
48:           str.gsub(/\\(\\|'|[0-3][0-7][0-7])/) {|s|
49:             if s.size == 2 then s[1,1] else s[1,3].oct.chr end
50:           }
51:         end
52:         ::Sequel::SQL::Blob.new(str)
53:       end

[Source]

    # File lib/sequel/adapters/shared/postgres.rb, line 41
41:       def date(s) ::Date.new(*s.split('-').map(&:to_i)) end

[Source]

    # File lib/sequel/adapters/shared/postgres.rb, line 29
29:       def float(s) 
30:         case s
31:         when 'NaN'
32:           NAN
33:         when 'Infinity'
34:           PLUS_INFINITY
35:         when '-Infinity'
36:           MINUS_INFINITY
37:         else
38:           s.to_f 
39:         end
40:       end

[Source]

    # File lib/sequel/adapters/shared/postgres.rb, line 28
28:       def integer(s) s.to_i end

[Validate]