Thread: Warning when connecting from PSQL Command

Warning when connecting from PSQL Command

From
danny
Date:
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.


Re: Warning when connecting from PSQL Command

From
Guillaume Lelarge
Date:
2015-05-29 20:13 GMT+02:00 danny <dinesh4202001@gmail.com>:
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


Yes, you're connected to the postgres database.


--

Re: Warning when connecting from PSQL Command

From
Harshad Adalkonda
Date:

On Fri, May 29, 2015 at 11:43 PM, danny <dinesh4202001@gmail.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@postgresql.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

Re: Warning when connecting from PSQL Command

From
Thomas Kellerer
Date:
Harshad Adalkonda schrieb am 30.05.2015 um 20:34:
>> On Fri, May 29, 2015 at 11:43 PM, danny <dinesh4202001@gmail.com <mailto:dinesh4202001@gmail.com>> wrote:
>>
>>     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
>>
>
> Don't mind the warning message it will always shown when you connect to psql terminal.

No, it will not "always" show if you follow the advice given in the manual and change the codepage in
the command line before starting psql:

    c:\>psql
    psql (9.4.2)
    WARNING: Console code page (850) differs from Windows code page (1252)
             8-bit characters might not work correctly. See psql reference
             page "Notes for Windows users" for details.
    Type "help" for help.

    postgres=> \q

    c:\>chcp 1252
    Active codepage: 1252.

    c:\>psql
    psql (9.4.2)
    Type "help" for help.

    postgres=>


Thomas