Re: Part way there, how do I complete it

From: ray <Ray(dot)Joseph(at)CDICorp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Part way there, how do I complete it
Date: 2009-04-15 21:17:47
Message-ID: 8df3b342-508c-430c-8c4b-056d58bb4309@u8g2000yqn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Apr 15, 3:15 pm, ray <Ray(dot)Jos(dot)(dot)(dot)(at)CDICorp(dot)com> wrote:
> I have just installed pgsql on a Windows XP from my administrator
<snip>
> 1)  The encoding is win1252, I wanted to make it unicode but I missed
> where to make that happen.  Can I change it for those things already
> built and for things in the future?  

I found that I can change this through the properties tab for the
existing db.

> 4)  Up to this point, there has been no change in the look or behavior
> of pgAdminIII.  So I went to File|Add server.  I added test01.  Now I
> do not like what I see in the object browser.  Can I change it?  It
> looks like:
>   Servers(1)
>     test01(localhost:5432)
>       Databases (2)
>         postgres
>         test
>       Tablespaces . . .
>
> Postgres and test dbs only showed up after I defined test01.  I do not
> want the top level server to be test01.  Is there a convension as to
> how to name this?  I expect to use pgsl for 4 different applications.
> I don't know if I can or should make these different servers or
> different databases.  And how do I change it?  What are the
> considerations?
>

I have found that I can change this by 'dropping' the test01 and
creating a new one. I would still like to know what naming
convensions are and how to choose a new server or db.

Thank,
Ray

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-04-15 21:31:18 Re: [GENERAL] Performance of full outer join in 8.3
Previous Message ray 2009-04-15 20:15:41 Part way there, how do I complete it