Henri
To get you started, this is what I do for a new install. (to get you into psql)
First of all you need a user, the only initial user is 'postgres'
Also, you need to specify a database, the default is the database that
is the same name as the user. There is one called 'postgres'
become the postgres user.
# su postgres (or sudo su postgres)
# psql
Welcome to psql 8.3.8, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# create role <you> with login superuser password <password>;
postgres=# ^D (or \q)
# ^D
you can now run psql as yourself, but you will want to create a
database to operate on...
# createdb <database>
# psql <database>
you're in. you will have noticed that you get
enjoy, psql rocks for command line data manipulation and piping (as a filter)
On Wed, Oct 14, 2009 at 1:42 PM, Henri De Feraudy <[email protected]> wrote:
> Hello,
> I just installed PostgreSL on windows XP. Now if I click on the Start button
> and then on Programs and then PostgreSQL 8.4 one of the items is "SQL shell
> (psql)".
> I cant find the documentation to this. In the document called PostgreSQL
> 8.4.1 documentation there is no occurrence of the word "Shell".
> Henri
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
Cheers!
Rick
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
