drop table if exists - Mailing list pgsql-sql

From Jason Watkins
Subject drop table if exists
Date
Msg-id 018b01c10406$8bcbaae0$426f2a40@boondocksaint
Whole thread Raw
Responses Re: drop table if exists  (Philip Hallstrom <philip@adhesivemedia.com>)
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: Martín Marqués
Date:
Subject: count(*)
Next
From: Martín Marqués
Date:
Subject: Re: count(*)