pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Warning when connecting from PSQL Command
4+ messages / 4 participants
[nested] [flat]

* Warning when connecting from PSQL Command
@ 2015-05-29 18:13 danny <dinesh4202001@gmail.com>
  2015-05-30 08:21 ` Re: Warning when connecting from PSQL Command Guillaume Lelarge <guillaume@lelarge.info>
  2015-05-30 18:34 ` Re: Warning when connecting from PSQL Command Harshad Adalkonda <adalkondaharshad@gmail.com>
  0 siblings, 2 replies; 4+ messages in thread

From: danny @ 2015-05-29 18:13 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Warning when connecting from PSQL Command
  2015-05-29 18:13 Warning when connecting from PSQL Command danny <dinesh4202001@gmail.com>
@ 2015-05-30 08:21 ` Guillaume Lelarge <guillaume@lelarge.info>
  1 sibling, 0 replies; 4+ messages in thread

From: Guillaume Lelarge @ 2015-05-30 08:21 UTC (permalink / raw)
  To: danny <dinesh4202001@gmail.com>; +Cc: pgsql-admin

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.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Warning when connecting from PSQL Command
  2015-05-29 18:13 Warning when connecting from PSQL Command danny <dinesh4202001@gmail.com>
@ 2015-05-30 18:34 ` Harshad Adalkonda <adalkondaharshad@gmail.com>
  2015-06-01 06:03   ` Re: Warning when connecting from PSQL Command Thomas Kellerer <spam_eater@gmx.net>
  1 sibling, 1 reply; 4+ messages in thread

From: Harshad Adalkonda @ 2015-05-30 18:34 UTC (permalink / raw)
  To: danny <dinesh4202001@gmail.com>; +Cc: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Warning when connecting from PSQL Command
  2015-05-29 18:13 Warning when connecting from PSQL Command danny <dinesh4202001@gmail.com>
  2015-05-30 18:34 ` Re: Warning when connecting from PSQL Command Harshad Adalkonda <adalkondaharshad@gmail.com>
@ 2015-06-01 06:03   ` Thomas Kellerer <spam_eater@gmx.net>
  0 siblings, 0 replies; 4+ messages in thread

From: Thomas Kellerer @ 2015-06-01 06:03 UTC (permalink / raw)
  To: pgsql-admin

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



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2015-06-01 06:03 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-05-29 18:13 Warning when connecting from PSQL Command danny <dinesh4202001@gmail.com>
2015-05-30 08:21 ` Guillaume Lelarge <guillaume@lelarge.info>
2015-05-30 18:34 ` Harshad Adalkonda <adalkondaharshad@gmail.com>
2015-06-01 06:03   ` Thomas Kellerer <spam_eater@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox