Learn how to drop all tables in PostgreSQL from command line without dropping the database. Complete guide with scripts, foreign key handling, and transaction safety tips.