Re: PSQL under Windows XP

Thanks John,

I found this utility but I am having problems getting
it to work properly. I posted a message to the general
group about my problem.

I understand now that there are command line utilities
in the bin directory to perform some functions.

You say you log on as the postgres user on the
template1 database.

The template1 database, is it actually a database
which I should see when using PGADMINIII, cause at
current I do not see it.

Let me say when I use PGADMINIII I am able to create a
database and specify whom is the owner.

But what I wanted to know is whether I can specify the
directory where my new database should appear.
I noticed that using createdb it is possible to
specify the location. Using PGADMINiii I do not see
the possibility.

Am I correct?

regards,
Danny

--- John DeSoi <desoi@pgedit.com> wrote:
>
> On May 30, 2005, at 9:52 AM, Kevin Crenshaw wrote:
>
> > What works for me is to log in as 'postgres' on
> the template1 database.
> > From there you can use the 'create database'
> command to create a new
> > database.  When that's done, quit template1 and
> then log in to the new
> > database as 'postgres'.
>
> Additionally, there is a createdb.exe command line
> utility specifically
> designed for this purpose (it should be in the same
> folder as psql). It
> is a little cleaner for this task since you do not
> have to specify an
> existing database to connect to.
>
>
http://www.postgresql.org/docs/8.0/interactive/app-createdb.html
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>



__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail