---
title: "Selecting All Columns Except One in Postgres"
publication: "Postgres Weekly"
issue: 257
published_at: "2018-05-23"
canonical_url: "https://postgresweekly.com/issues/257"
---

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

#257 — May 23, 2018 

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

Postgres Weekly  

[A Draft of the Postgres 11 Release Notes](https://www.postgresql.org/docs/devel/static/release-11.html) — Bruce Momjian has completed the draft version of the release notes for the forthcoming Postgres 11 release — so if you want to see what’ll be coming to Postgres soon, this is your one stop shop. 

Bruce Momjian   

[Selecting All Columns Except One in Postgres](https://blog.jooq.org/2018/05/14/selecting-all-columns-except-one-in-postgresql/) — Google’s BigQuery has `EXCEPT` and `REPLACE` keywords for removing or replacing column results mid-query. Here’s a look at emulating such functionality on Postgres. 

Lukas Eder   [![\](https://copm.s3.amazonaws.com/231dfc43.jpg)](https://www.2ndquadrant.com/en/support/support-postgresql/?utm_source=cp&utm_medium=text&utm_campaign=cpsupport) 

[When It's Critical You Can Count on 2ndQuadrant](https://www.2ndquadrant.com/en/support/support-postgresql/?utm_source=cp&utm_medium=text&utm_campaign=cpsupport) — 2ndQuadrant support engineers have over 100 years of combined code contributions to the PostgreSQL project. We provide a guaranteed 15 minute response time and 24-hour bug fix - recovering your database quickly with minimal downtime. 

2ndQuadrant PostgreSQL Services sponsor   

[Are Triggers Really That Slow in Postgres?](https://www.cybertec-postgresql.com/en/are-triggers-really-that-slow-in-postgres/) — Postgres enables use of database side triggers for all kinds of use cases. From the performance side they are in most cases actually harmless as these results reveal. 

Kaarel Moppel   

[Preparing Your Multi-Tenant App for Scale](https://www.citusdata.com/blog/2018/05/22/planning-multi-tenant-for-scale/) — Three key steps worth taking to ensure you won’t waste time when/if your database needs to scale. 

Craig Kerstiens   

[Understanding Deadlocks in Postgres (and MySQL)](https://severalnines.com/blog/understanding-deadlocks-mysql-postgresql) — A look at what deadlocks are, why they happen, and some suggestions on how to manage them. 

Sebastian Insausti   

[Full Text Search Made (Almost) Right in Postgres 11](http://akorotkov.github.io/blog/2018/05/21/fulltext-search-made-almost-right/) — A look into how RUM indexes on Postgres 11 will make TOP-N and COUNT(*) queries for non-selective full text search queries significantly more efficient. 

Alexander Korotkov   

[Mapping Oracle Datatypes to PostgreSQL](https://www.cybertec-postgresql.com/en/mapping-oracle-datatypes-to-postgresql/) — A table to help you map Oracle datatypes to Postgres ones. 

Hans-Jürgen Schönig   

[Real-Time Postgres Performance Monitoring. Try Datadog Free](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyB) 

Datadog sponsor   

[Prisma Now Supports Postgres: Bring GraphQL to Postgres](https://blog.graph.cool/prisma-now-supports-postgres-aad74ba479cb) — Prisma is an open source layer for bringing GraphQL capabilities to existing databases and Prisma 1.8 introduces support for PostgreSQL. 

Graphcool tools  

Events  

[Postgres Vision 2018](http://postgresvision.com/) — **June 5-6 (Boston, USA)** Postgres in the Cloud - Front and center at Postgres Vision 2018.    

[PGDay.IT 2018](https://2018.pgday.it/it/) — **June 28 - 29 (Pacengo di Lazise, Italy)** The Italian conference dedicated to PostgreSQL.    

[PGConf UK 2018](https://www.postgresql.org/about/event/2224/) — **July 2- 3 (London, UK)** Will be held on July 3, with an optional training day on July 2, and will be hosted at 30 Euston Square.          

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