Received: from e4500a.callatg.com (e4500a.atgi.net [216.174.194.60]) by postgresql.org (8.11.3/8.11.1) with SMTP id f63LIva84806 for ; Tue, 3 Jul 2001 17:18:57 -0400 (EDT) (envelope-from jason_watkins@pobox.com) Received: (qmail 7311 invoked from network); 3 Jul 2001 21:18:53 -0000 Received: from unknown (HELO boondocksaint) (64.42.111.66) by e4500a.callatg.com with SMTP; 3 Jul 2001 21:18:53 -0000 Message-ID: <018b01c10406$8bcbaae0$426f2a40@boondocksaint> From: "Jason Watkins" To: Subject: drop table if exists Date: Tue, 3 Jul 2001 14:24:29 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200107/27 X-Sequence-Number: 3808 How can I duplicate the behavior of: DROP TABLE IF EXISTS mytable; CREATE TABLE mytable ( blah, blah ); INSERT INTO mytable (blah) VALUES (blah); in other words, so that I have a single sql file that restores the database to a known state.