Skip site navigation (1) Skip section navigation (2)

Re: REALLY stupid question

From: "Keith Turner" <kturner(at)cloudsystems(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: REALLY stupid question
Date: 2009-01-30 16:35:06
Message-ID: E15577A9B0DBD9489F41C761934D08C874DA97@cloudfs1.cloudsystems.com (view raw or flat)
Thread:
Lists: pgsql-novice
I believe in 8.3 on Windows the client utility is named pgAdmin3 not
pgAdminIII

It is installed in the postgresql folder under the start button program
files in Windows as part of the windows install of postgresql.

After you open from the same machine that postgres is on, there should
be a list on the left that includes something like "PostgreSQL Database
Server 8.3 (localhost:5432)" - that is the local instance - right click
on it and from the pop up menu select connect. You will then have your
database interface. You can then do most maintenance, create databases,
tables, etc. 

PgAdmin3 also has the help file bundled  into it - including information
on how to use the command line psql tool. If you want to use psql from
any folder in a command window, you'll need to add it to the "path"
environmental variable. Otherwise you'll need to be in the bin folder in
order to use (this is something like "C:\Program
Files\PostgreSQL\8.3\bin")

Keith 

Right click on the local

-----Original Message-----
From: Bob McConnell [mailto:rmcconne(at)lightlink(dot)com] 
Sent: Thursday, January 29, 2009 4:26 PM
To: Rebecca Jones
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: REALLY stupid question

Rebecca Jones wrote:
> Greetings, all -
> 
> Now that I've installed version 8.3.4 on my WinXP HP laptop, how do I
> interface with the RDBMS?  I know how to start and stop the server,
> even without really knowing what I'm doing thereby.  But when I
> activate the SQL command window I'm faced with having to supply
> several parameters that I don't recall setting and haven't a clue why
> I'd need to set them, i.e. "server", "port", etc.  I can live without
> a hand-holding interface like Access provides, but I need a little
> middle ground here - what's the application I should be using to
> create, load, etc. DBs?
> 
> I do have some SQL experience, but it's all in a canned, administered
> environment such as host-based DB2 or stand-alone Access.  I have no
> experience as a DBA, so you can see how clueless I truly am ...

Hi Rebecca,

As others have mentioned, psql should already be available, and 
PgAdminIII is an excellent client for administrators and developers. It 
displays and allows you to update just about every option and feature in

the server. It also provides a hierarchical view of the DBMS, and any 
databases, schema's, roles, views, scripts, etc. that are in there.

After that, it depends on your applications and tools. With a web 
server, PHP can be compiled with Postgres support built in. For Perl, 
there is DBI with the Postgres DBD drivers. I know there are libraries 
around for C and C++, as well as Java and several other languages. 
OpenOffice.Base can use it as a back end. If you can provide a few more 
details about what you are trying to do, I'm sure there is someone that 
can point you in the right direction.

Bob McConnell
N2SPP

In response to

pgsql-novice by date

Next:From: Raimon FernandezDate: 2009-01-30 16:38:47
Subject: boot on Debian with /etc/init.d/rc ...
Previous:From: Tom LaneDate: 2009-01-30 01:16:22
Subject: Re: How to log to postgresql.log

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group