What Does INSERT 0 1 Actually Tell You? | My DBA Notebook
If you’ve ever run an insert statement in a terminal or an IDE, you’ve seen it: the cryptic insert 0 1 message. While it looks like a bit of ancient binary, it’s actually a precise status report from the database engine.
The Anatomy of a Command Tag 🔗In PostgreSQL, every successful command returns a “Command Tag.” For an insertion, the format is: INSERT [oid] [rows]
The “0” (oid1): Historically, Postgres could assign an internal Object ID to every row.
