Postgresql LC_monetary format issue

$10-30 USD

Closed

Posted

about 1 year ago

$10-30 USD

Paid on delivery

I have two postgresql servers version 14.3 one installed in Ubuntu and the other in Red hat. I am having issues about the format of LC_monetary in Postgresql in Redhat Both servers are configured with the same LC_monetary but the format of the currency output shows correctly only in Ubuntu menawhile in Redhat shows other format. When I do a select in the table of Postgresql in Ubuntu the money field shows correctly Bs But when I do a select in the table of Postgresql in Redhat the money field shows $b Looks like LC_monetary version of postgres is different in Redhat or something like that. I need the Redhat-Postgresql output be like Ubuntu-Postgresql

Linux

PostgreSQL

Database Administration

Red Hat

Database Management

Project ID: 36553294

About the project

2 proposals

Remote project

Active 11 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

2 freelancers are bidding on average $15 USD for this job

@inidessl

I hope this can help, it is a clip from my PostgreSQL Document. "8.2. Monetary Types The money type stores a currency amount with a fixed fractional precision; see Table 8.3. The fractional precision is determined by the database's lc_monetary setting. The range shown in the table assumes there are two fractional digits. Input is accepted in a variety of formats, including integer and floating-point literals, as well as typical currency formatting, such as '$1,000.00'. Output is generally in the latter form but depends on the locale." According to the last sentence, you should check the server-level configured country and formats, using the 'locale' or a related command. Have a nice day.

$10 USD in 7 days