Re: Syntax question - Mailing list pgsql-admin

From Andrew Biagioni
Subject Re: Syntax question
Date
Msg-id 40C4EC17.4060208@e-greek.net
Whole thread Raw
In response to Syntax question  ("Jeff Stout" <jstout@cctus.com>)
Responses pg_ctl question
List pgsql-admin
Jeff,

you need to look under "\?" (psql commands), not "\h" (SQL commands).

Anyway, what you need is:

  \c[onnect] [DBNAME|- [USER]]
                 connect to new database (currently "[...]")


Jeff Stout wrote:

> I am fairly new to postgres, I need to know how to switch
> databases once I'm in a psql session. I can't seem to find the
> command for \h , maybe I just blind |-;
>
> Thank you in advance
>
> Jeff Stout
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>
>
>

pgsql-admin by date:

Previous
From: Andrew Biagioni
Date:
Subject: Re: E-R Tool
Next
From: Adi Alurkar
Date:
Subject: out of memory error