---
title: "#254: An example of Postgres 11's CREATE PROCEDURE"
publication: "Postgres Weekly"
issue: 254
published_at: "2018-05-02"
canonical_url: "https://postgresweekly.com/issues/254"
---

The latest Postgres news, articles, tools, and projects.       

#254 — May 2, 2018 

[Read on the Web](https://postgresweekly.com/issues/254)   

Postgres Weekly 

[![Inserting JSON with SQL\](https://res.cloudinary.com/cpress/image/upload/w_800/avdw63t0osbg1zncvad0.jpg)](https://tapoueh.org/blog/2018/04/postgresql-data-types-json/)  

[Postgres Data Types: JSON (and XML)](https://tapoueh.org/blog/2018/04/postgresql-data-types-json/) — The latest in a fantastic series digging into Postgres’ support for various types of data. This week it’s JSON, and [XML has been covered too.](https://tapoueh.org/blog/2018/04/postgresql-data-types-xml/) 

Dimitri Fontaine   

[A Quick Look at How Postgres 11's CREATE PROCEDURE Feature Will Work](https://www.cybertec-postgresql.com/en/tech-preview-postgresql-11-create-procedure/) — `CREATE PROCEDURE` will give us the power to to run transactions in procedural code. A brief example here. 

Hans-Jürgen Schönig   [![\](https://copm.s3.amazonaws.com/068715ec.png)](http://postgresvision.com/) 

[Postgres Vision Keynote Speakers Announced](http://postgresvision.com/) — Jeff Sutherland, inventor of the SCRUM, Lauren Nelson, principal analyst, Forrester, and Dan Lyons, author of: Options: The Secret Life of Steve Jobs and Disrupted: My Misadventure in the Start-Up Bubble. 

Postgres Vision 2018 sponsor   

[Comparing Cloud Database Options for PostgreSQL](https://severalnines.com/blog/comparing-cloud-database-options-postgresql) — A high level comparison of Amazon RDS, Google Cloud SQL, Azure’s Postgres offering, Heroku, EnterpriseDB, Citus DB Cloud, and ElephantSQL. 

Severalnines   

[PipelineDB 0.9.9: One More Release Until PipelineDB is a Postgres Extension](https://www.pipelinedb.com/blog/pipelinedb-0-9-9-one-more-release-until-pipelinedb-is-a-postgresql-extension) — PipelineDB is a _fork_ of Postgres that turns it into a streaming time series database, but it’s quickly on its way to becoming an extension instead. 

Derek Nelson   

[pg_wal Is Too Big.. What's Going On?](http://blog.dataegret.com/2018/04/pgwal-is-too-big-whats-going-on.html) — The tale behind working out why a Postgres server failed due to running out of disk space and how to mitigate the problem in future. 

Alexey Lesovsky   

[Using SQL to Query Postgres and Other Databases with Presto](http://tech.marksblogg.com/presto-connectors-kafka-mongodb-mysql-postgresql-redis.html) — [Presto](https://prestodb.io/) is a distributed SQL query engine by Facebook that can connect to other data sources, as demonstrated here. 

Mark Litwintschik   

[Announcing the Release of AgensGraph 1.3](https://www.postgresql.org/about/news/1848/) — AgensGraph is a multi-model graph database based on Postgres. 

Bitnine Global   

[Coming to PostgreSQL 11: Partition Pruning At Execution Time](https://www.depesz.com/2018/05/01/waiting-for-postgresql-11-support-partition-pruning-at-execution-time/) 

Hubert depesz Lubaczewski   

[Unified Management & Automation for PostgreSQL](https://severalnines.com/product/clustercontrol/for_postgresql?utm_campaign=Crisis_Campaign_MAY_2018&utm_content=pg_weekly&utm_medium=Paid_Search&utm_source=banner) 

Severalnines sponsor   

[ora_migrator: Moving From Oracle to Postgres Even Faster](https://www.cybertec-postgresql.com/en/ora_migrator-moving-from-oracle-to-postgresql-even-faster/) — Want to migrate an Oracle database to Postgres with a single SQL query? 

Hans-Jürgen Schönig         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom