Hi everyone,

I have a little question.
I try to extract some datas from a table and insert them in an other table (the same in an other database).
In some columns, I have a space. This column is a character varying and is not null. I agree with you, a space to bypass the not null is not something great...
But when I do my select, the space disapears and it makes an error when I try to insert it.

Is there a way to keep my space in the column. If possible, other than replace the column because I try to use something generic (select * from ${TABLE}) cause I have a lot of tables.

I hope I have been clear.