Skip to main content

Library to use more sql-commands

Project description

sqlextension

This module makes some SQL commands available for use with python-sql.

Install

pip install mds-sqlextension

Available SQL commands

  • StringAgg (string_agg)
  • Ascii (ascii)
  • Concat2 (concat)
  • RPad (rpad)
  • Lower (lower)
  • ArrayAgg (array_agg)
  • Replace (replace)
  • AnyInArray (any)
  • FuzzyEqal (%)

To make FuzzyEqual work, call CREATE EXTENSION pg_trgm; in PostgreSQL.

Requires

  • python-sql

Changes

0.1 - 06/09/2017

  • first public version

Project details


Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page