Re: Data Type to store Leading Zero(0) - Mailing list pgsql-admin

Nidhi Gupta <nidhig631@gmail.com> wrote:
> As per business needs we need to store Zero(0) in primary key column of table
> with this kind of value à  07******** with applications written in Java microservices.
>  
> We are not able to use numeric data type as it trims the Zero value in leading,
>  but it’s also a performance impact if we define varchar in the data type.


Use "integer" and define a view that pads the column with zeros on the
left side:

CREATE VIEW myview AS
SELECT lpad(if::text, 10, '0') AS id,
       othercolumn,
       ...
FROM mytable;

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com