Bio

Lætitia is a PostgreSQL expert in France. She begun working with PostgreSQL in 2007. She also had to learn Oracle and SQL Server at the same time. She had a lot of exciting experiences with high availability, production crashes, disaster recovery plan, load balancing, spatial data...

Talk Description: `psql` is awesome!

Here's a secret you might not know: `psql` is a great tool! The more I learn about it, the more I want to learn about it. After rendering the webpage `psql-tips`, I decided to compile my best tips on those slides to make you become more efficient easily and quickly with `psql`! The talk will go through several questions. the first obvious one is why would I bother to learn CLI when I can do whatever I need with a GUI tool? We'll try to answer why knowing CLI is a MUST for some people (like Postgres DBAs, for example) whereas it's only a bonus for others (like data scientists, for example).

Then we'll go through the basics about 101 (how to connect to, interactive mode versus not interactive more, how to set psql environment to work comfortably and so on...)

The last part will be about tips and tricks that will make anyone's journey with psql more effective and enjoyable. I'm looking for the "TIL" effect in people's eyes. Level: beginner

Slides