Thread: Warning when connecting from PSQL Command
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.
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.
--
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.
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