MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

From: "Paragon Corporation" <lr(at)pcorp(dot)us>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane
Date: 2013-08-15 05:39:25
Message-ID: FF4A8544F7714A3DA09871DE0694C60A@O
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Attila Soki 2013-08-15 08:32:59 Foreign key match is unknown when using with postgresql 9.3b2
Previous Message Dinesh Kumar 2013-08-14 19:35:51 Re: Password setting having somewhat bizarre results.