I'm trying to run the following script through interactive postgres.
CONNECT DATABASE BASEBALL;
CREATE UNIQUE index1 on team(team_name);
If I start postgres as
>psql baseball
the script runs no problem. If I start it as
>pgsql template1 (or any other database) I get a
cann't connect to database error. So my question is
how do I connect to more than one database at a time?