I'm running pgAdmin 1.18.0 Alpha 1 on Windows IF I create a view
CREATE MATERIALIZED VIEW mat_test AS SELECT generate_series(1,10) ; Then look at the view in the SQL pane, it shows this: CREATE OR REPLACE VIEW public.mat_test AS SELECT generate_series(1, 10) AS generate_series; Thanks, Regina -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support