SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 05:40 AM
| ||||
| ||||
 Re: drop table before create >I have not been able to work out how to do this is Postgres 8 >(pseudo-code) > > if exists table foo > drop table foo; > end > create table foo; > >If I go with > > drop table foo; > create table foo; > >then it barfs on an empty db. >The assumption here is that the SQL is coming in on a script via the >programmatic interface. Slurp in a bunch of SQL commands and then fire >them at the database. > There are a couple of commands that may help you: \set ON_ERROR_STOP \unset ON_ERROR_STOP __________________________________________________ _______________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/g...ave/direct/01/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
|
04-09-2008, 05:41 AM
| ||||
| ||||
| Re: drop table before create am 26.08.2005, um 2:11:30 +0430 mailte Lee Harr folgendes: > >I have not been able to work out how to do this is Postgres 8 > >(pseudo-code) > > if exists table foo > > drop table foo; > > end > > create table foo; > >If I go with > > drop table foo; > > create table foo; > >then it barfs on an empty db. Perhaps this will help you: http://www.milwaukeesoft.com/forums/...3407692 c5db4 Regards, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
Linear Mode
