-- Ancienne table

CREATE TABLE person (
    id INT,
    DATE VARCHAR
);

-- Nouvelle table
ALTER TABLE person ALTER DATE TYPE DATE USING (DATE::DATE);

CREATE schema v1;

CREATE schema v2;

CREATE VIEW v1.person AS (
    SELECT id,
    DATE::VARCHAR
    FROM public.person
);

-- Exemple:

SET SEARCH_PATH TO v2, public;

\d person

SET SEARCH_PATH TO v1, public;

\d person