RETURN VALUES ON INTEGERS - Mailing list pgsql-sql

I have the following DATABASE.

CREATE TABLE codestatus    (id                int primary key,code                int,status                char
);

code is an int number made at least of 6 numbers.
(range from 0 up to 999999)

If i do :

select * from codestatus;

I GET:

id|code|status
--+------+------1| 44111|N    2|   123|S

BUT I WOULD LIKE TO GET

id|code|status
--+------+------1|044111|N    2|000123|S

How could I fix the prbolem and get the values as I ned them out of the
select ?

thanks in advance

Alex