Re: Warning when connecting from PSQL Command

From: Harshad Adalkonda <adalkondaharshad(at)gmail(dot)com>
To: danny <dinesh4202001(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Warning when connecting from PSQL Command
Date: 2015-05-30 18:34:49
Message-ID: CANnQH_ixaKcs_sCmh7kRTxoK=opKZutqF-c4VU5HtOoJYHWEJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, May 29, 2015 at 11:43 PM, danny <dinesh4202001(at)gmail(dot)com> wrote:

> New to Postgres please help
>
> Warning console code page (437) differs from Window code page (1252) 8- bit
> character might not work correctly. See psql reference page "Notes for
> windows users" for details
> Type "Help" for help
>
> Postgres-#
>
> When I type help it gives couple of commands
>
> When I type
>
> Postgres-# \c
> It giives the above message again
> Warning console code page (437) differs from Window code page (1252) 8- bit
> character might not work correctly. See psql reference page "Notes for
> windows users" for details
>
> You are now connected to database "postges" as user "postgres"
> postgres=#
>
> does it mean am I connected and do my operations
>
> Thanks,
> Danny
>
>
>
> --
> View this message in context:
> http://postgresql.nabble.com/Warning-when-connecting-from-PSQL-Command-tp5851717.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

Hi Danny,

Don't mind the warning message it will always shown when you connect to
psql terminal.

\c is used to connect other database available in the cluster.

Syntax:

\c database_name user_name

Example:

\c test postgres

Hope this will help you to understand.

--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Boylan, Ross 2015-05-30 21:14:15 Re: PostgreSQL 9.1 "database system was interrupted; last known up at"
Previous Message Guillaume Lelarge 2015-05-30 08:21:03 Re: Warning when connecting from PSQL Command