rjuju/sql2pg

SQL

Stars
5
Rank 2,861,937 (Top 57 %)
Language
Perl
License
GNU General Publi...
Created over 7 years ago
Updated almost 3 years ago

rjuju/sql2pg

rjuju

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

SQL parser to convert different SQL flavor to PostgreSQL compatible SQL

sql2pg

/!\ WARNING /!\

This project is still a work in progress, SQL grammar are big and complex. If you encounter some statements that are not handled, please report an issue with a self contained case and a link to the grammar reference.

Overview

sql2pg is a parser that converts various flavor of SQL to PostgreSQL compatible SQL.

It'll convert automatically most of specific keywords (CONNECT BY, (+)...), type, functions and so on.

Things that can't be automatically converted will be exported as SQL comments after its problematic query.

Dependencies

sql2pg requires Marpa::R2, at least version 2.076000.

Usage

For Oracle SQL:

plsql2pg.pl queries.sql > rewritten_queries.sql

For SQL Server SQL:

tsql2pg.pl queries.sql > rewritten_queries.sql

pg_track_settings

Small extension to keep track of postgresql settings modification

pg_anonymize

PostgreSQL dynamic data anonymization

pg_validate_extupgrade

PostgreSQL extension upgrade script validation

pg_shared_plans

Shared cache plans for PostgreSQL

pg_show_rewritten_query

Print a query after rewrite stage

pg_queryid

External query fingerprinting for PostgreSQL

pg_dropbuffers

Toy extension to drop buffers from shared_buffers without needing to restart the cluster.

pg_extension_template

Some basic template to help starting a new postgres extension

postgres-manage

pg_read_uncommitted

pgpermissions

Simple tool to summarize ACLs on a PostgreSQL cluster

pg_msvc_generator

Automatically generate MSVC project for PostgreSQL extensions.

ingredients_plugin

pg_timelord

pgCompare

pgstatus

Mojolicious application to monitor PostgreSQL activity.

pg_collation_dependencies

Find collation dependencies that may be corrupted in case of an underlying collation library upgrade