From: | "Rommel B(dot) Abaya" <rommel(dot)abaya(at)ramcargroup(dot)com> |
---|---|
To: | Srinivasa R Chava <s(dot)chava(at)wcom(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: how to connect remote database |
Date: | 2001-07-17 00:54:20 |
Message-ID: | 3B538CBC.5DC5A33B@ramcargroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
psql <databasename> -h <hostname/ip address> -U <username>
e.g. To connect to database customers on server gravy from server xxx :
psql customers -h gravy -U mypassword
-- rba
hth
Srinivasa R Chava wrote:
> Hai,
> How to connect the database from remote client ,using psql
> In oracle we use the command like the following one at sqlplus
> prompt.
> Sqlplus> username/password(at)hostname
>
> How to do it in postgresql
> I tried like this
> psql dabasename username(at)hostname
>
> It is not working.
>
> Can anybody has an idea?
> Thanks
> chava
> --
>
> Srinivasa R Chava (Chava) <s(dot)chava(at)wcom(dot)com>
> Application Developer
> Corporate Intra/Internet Systems
> WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM
> 500 Clinton Center Drive (Corporate Headquarters)
> Clinton, Mississippi (MS) USA 39056
> (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
Attachment | Content-Type | Size |
---|---|---|
rommel.abaya.vcf | text/x-vcard | 204 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Marian Sabo | 2001-07-17 08:05:02 | HOW-TO migrate database |
Previous Message | Tom Lane | 2001-07-16 22:59:57 | Re: Vacuum |