From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Rommel the iCeMAn <icecrew@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Change Default Database
Date: Mon, 26 Feb 2007 15:39:23 -0600
Message-ID: <1172525963.20651.39.camel@state.g2switchworks.com> (raw)
In-Reply-To: <00c001c759e8$0b124560$b364a8c0@theport.com>
References: <00c001c759e8$0b124560$b364a8c0@theport.com>
On Mon, 2007-02-26 at 14:52, Rommel the iCeMAn wrote:
> Hi again,
>
> Apologies for the HTML.
>
> This is an SQL script, it was generated by doing a schema-only database dump
> using pgAdminIII (which in turn uses pgdump I believe). I've attached the
> entire script. I was attempting to run this script in pgAdminIII because
> that's what I used to generate it, but the more I read it seems I should try
> the psql command line tool to execute this script. I'm getting the
> impression that pgAdmin doesn't recognize the /connect directive.
Please CC the list, as more eyes are more likely to have an answer than
just mine...
Yeah, I always run my scripts from psql, often called from a bash shell
script. That way I can substitute server / database names in the shell
script depending on what I'm trying to do.
\ commands exist within the framework of psql, not outside. If pgAdmin
doesn't have an equivalent type of command structure, then it won't work
for this. You could always drop the db by hand, create it, connect to
it, and THEN run the rest of your script, but I too think it would be
easier to just run the script against psql.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smarlowe@g2switchworks.com, icecrew@gmail.com
Subject: Re: Change Default Database
In-Reply-To: <1172525963.20651.39.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox