Charl Gerber <cpger@xxxxxxxxx> writes: > There is one 'install.sql' file which does something like: > DROP DATABASE db_name IF EXISTS (<--- is there something similar in > Postgre? Like the CREATE OR REPLACE FUNCTION) > CREATE DATABASE db_name; There's no IF EXISTS. Usually people just do a DROP and ignore the error if any. > How do you do this with Postgre? I tried using the "insert filename" > command, but one file cannot seem to load another (ie, a SELECT filename > gives me an error) and to start with, I cannot find something similar to > "USE DATABASE" .... You probably want to be looking at psql's \i and \c commands, respectively. Does "insert foo" really mean a file inclusion command in MySQL? Bizarre ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
