In this video we look behind the curtain of PostgresSQL and see how a single SELECT * FROM translate into the TCP stack. We will create a TCP postgres connection, authenticate, send the query, close the connection.

#wireshark_them_all

0:00 Intro
0:30 Describe the Code
1:30 Wiresharking Postgres
2:00 Authentication
5:30 SELECT * FROM
7:30 Closing Connection
9:10 Bad Connection Example

#postgresql