{"repo":"lacanoid/pgddl","free":true,"listed":false,"github":"https://github.com/lacanoid/pgddl","clone":"git clone https://github.com/lacanoid/pgddl.git","description":"DDL eXtractor functions for PostgreSQL (ddlx)","language":"PLpgSQL","stars":155,"topics":["postgresql-extension","ddl","database","sql","postgresql"],"license":null,"category":"databases-storage","readme_excerpt":"DDL eXtractor functions for PostgreSQL ======================================= This is an SQL-only extension for PostgreSQL that provides uniform functions for generating SQL Data Definition Language (DDL) scripts for objects created in a database. It contains a bunch of SQL functions to convert PostgreSQL system catalogs to nicely formatted snippets of SQL DDL, such as CREATE TABLE. Some other SQL databases support commands like SHOW CREATE TABLE or provide other facilities for the purpose. PostgreSQL currently doesn't provide overall in-server DDL extracting functions, but rather a separate pg dump program. It is an external tool to the server and therefore requires shell access or local installation to be of use. PostgreSQL however already provides a number of helper functions which greatly help with reconstructing DDL and are of course used by this extension. PostgreSQL also has sophisticated query capabilities, such as common table expressions and window functions which make this project possible by using only SQL. Advantages over using other tools like psql or pg dump include: - You can use it to extract DDL with any client which support running plain SQL queries - Simple API with just three functions. Just supply oid . - No shell access or shell commands with hairy options required (for running pg dump), just use SELECT and hairy SQL instead! - With SQL you can select things to dump by using usual SQL semantics (WHERE, etc) - Special function for creating scripts, whic","default_branch":null,"files":null,"tree":[],"storefront":"/r/lacanoid","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/lacanoid/pgddl/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}