RE: Re: drop table if exists
От | Maxim Maletsky |
---|---|
Тема | RE: Re: drop table if exists |
Дата | |
Msg-id | DC017B079D81D411998C009027B7112A015ED3E6@EXC-TYO-01 обсуждение исходный текст |
Ответ на | drop table if exists ("Jason Watkins" <jason_watkins@pobox.com>) |
Список | pgsql-sql |
Alright, but what about when you're writing a long dump file with all these sequences, functions not speaking about the tables themselves. When I drop something I wanna make sure it out the database (but still cannot empty the whole database before), so I have DROP TABLE ..., ..., ..., ...; DROP FUNCTION ..., ..., ..., ...; DROP SEQUENCE ..., ..., ..., ...; If one of these were not there, the whole dump crashes and I need to restart the process modifying the SQL file. I'd LOVE to have a magic 'IF EXISTS' like in mySQL - make life easier (Although I totally disrespect mySQL). Has anyone a work around for this? Thanks, and yes, sorry for the late post, just looked you up guys. Sincerely, Maxim MaletskyFounder, Chief DeveloperPHPBeginner.com (Where PHP Begins)maxim@phpbeginner.comwww.phpbeginner.com -----Original Message----- From: Philip Hallstrom [mailto:philip@adhesivemedia.com] Sent: Wednesday, July 04, 2001 7:39 AM To: Jason Watkins Cc: pgsql-sql@postgresql.org Subject: [SQL] Re: drop table if exists Just drop the table using "DROP TABLE mytable;" and ignore the error... I'm sure there are fancy ways of doing it by accessing system tables, but the above works for me. On Tue, 3 Jul 2001, Jason Watkins wrote: > 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. > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
В списке pgsql-sql по дате отправления: