Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

Change language of system and error messages in PostgreSQL

Tags:

postgresql

Is it possible to change the language of system messages from PostgreSQL?

In MSSQL for instance this is possible with the SQL statement SET LANGUAGE.

like image

327

asked Oct 10 '08 14:10

Benno Richters

People also ask

Which language is a loadable procedural language for PostgreSQL?

PL/Tcl is a loadable procedural language for the PostgreSQL database system that enables the Tcl language to be used to write functions and trigger procedures.

1 Answers

SET lc_messages TO 'en_US.UTF-8';

More info on requirements and limitations here.

like image

107

answered Sep 24 '22 15:09

Milen A. Radev

Sign in to Comment

Related questions
                            
                                how do I group by by hour in postgresql with a "time" field?
                            
                                Database that can handle >500 millions rows
                            
                                How to set a Postgresql default value datestamp like 'YYYYMM'?
                            
                                PostgreSQL Get a random datetime/timestamp between two datetime/timestamp
                            
                                Remove double quotes from the return of a function in PostgreSQL
                            
                                Entity Framework core - Contains is case sensitive or case insensitive?
                            
                                currval has not yet been defined this session, how to get multi-session sequences?
                            
                                Improving Postgres psycopg2 query performance for Python to the same level of Java's JDBC driver
                            
                                UUID Primary Key in Postgres, What Insert Performance Impact?
                            
                                SELECT or INSERT a row in one command
                            
                                Creating a postgresql DB using psycopg2
                            
                                How to connect GraphQL and PostgreSQL
                            
                                Cast string to number, interpreting null or empty string as 0
                            
                                How to store array or multiple values in one column
                            
                                What is the maximum number of columns in a PostgreSQL select query
                            
                                Passing user id to PostgreSQL triggers
                            
                                Could not translate host name "db" to address using Postgres, Docker Compose and Psycopg2
                            
                                Escape SQL "LIKE" value for Postgres with psycopg2
                            
                                What does exclusion constraint `EXCLUDE USING gist (c WITH &&)` mean?
                            
                                psql: server closed the connection unexepectedly

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With