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;
USE db_name;
SOURCE users.sql; SOURCE teams.sql; SOURCE players.sql;
etc.
Using the mysql command like tool, you just run "source install.sql" and the whole database is loaded.
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" ....
Thanks!
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
