MySQL's command line tool has a flag --i-am-a-dummy that sets execution limits:
With --safe-updates, you can modify rows only by specifying the key values that identify them, or a LIMIT clause, or both. This helps prevent accidents. Safe-updates mode also restricts SELECT statements that produce (or are estimated to produce) very large result sets.
Is there a way to turn on similar features in psql?