Mastering PostgreSQL

Welcome to Dimitri Fontaine's website!


In this place I share my PostgreSQL expertise. You will find about my projects of course, and the blog is full of interesting articles: have a try at Understanding Window Functions which has been helpful to many readers! This article is even part of a data driven series of post, the YeSQL category, check it out!

Also, I’m writing a book about Mastering PostgreSQL in Application Development, and you can subscribe to get sample content before anyone else and be the first to get the book when it’s available!


Le 21 avril prochain se tient le premier pgDay Paris: une conférence PostgreSQL d’une journée complète. Il s’agit de 8 conférences sur votre base de données préférée par des conférencers internationaux, incluant des retours d’expérience et une analyse de l’utilisation des derniers développements en cours dans notre projet de base de données préféré.


PostgreSQL comes with an awesome bulk copy protocol and tooling best known as the COPY and \copy commands. Being a transactional system, PostgreSQL COPY implementation will ROLLBACK any work done if a single error is found in the data set you’re importing. That’s the reason why pgloader got started: it provides with error handling for the COPY protocol.


Dimitri Fontaine

PostgreSQL Major Contributor

Open Source Software Engineer

France