fatal database postgres does not exist

Solutions on MaxInterview for fatal database postgres does not exist by the best coders in the world

showing results for - "fatal database postgres does not exist"
Ilona
14 Aug 2017
1psql -d template1
2
Serena
03 Apr 2016
1If the field is already a string, this will work
2
3 SELECT RIGHT('000'+ISNULL(field,''),3)
4If you want nulls to show as '000'
5
6It might be an integer -- then you would want
7
8 SELECT RIGHT('000'+CAST(field AS VARCHAR(3)),3)