CODEWITHSUNDEEP
postgresqlpsql
Chris S
Chris S

Reputation: 11

Permanently set thousend separator for PostgreSQL PSQL?

I use the following command to set thousand comma separator in PSQL every time i log in, but how do i set it permanently? 

\pset numericlocale

Upvotes: 1

Views: 161

Answers (1)

redneb
redneb

Reputation: 23870

You can put that line in your psqlrc file which is located at ~/.psqlrc.

Upvotes: 2

Related Questions