Materialized view

Asked

Viewed 66 times

0

I’m having a problem creating a view 

CREATE MATERIALIZED VIEW table_name

You’re making this mistake:

ERROR: syntax error at or near "MATERIALIZED" LINE 1: CREATE MATERIALIZED VIEW sige.view_geral_lote AS ******** Error

ERROR: syntax error at or near "MATERIALIZED" SQL state: 42601 Character: 8

when I try to create this view but do not know the reason for the error, could help me ?

postgresql view
  • 1

    Olá Gabriel, "but I don’t know the reason for the mistake" we also do not, what error message? can put the full sql code that is running to help understand the error?

  • Sorry for the lack of information , below is the error you are giving ERROR: syntax error at or near "MATERIALIZED" LINE 1: CREATE MATERIALIZED VIEW sige.view_geral_lote AS *********************** ERROR: syntax error at or near "MATERIALIZED" SQL state: 42601 Character: 8

  • Gabriel, you can add the message in the question, it is better to analyze. Click on the link "edit" or here and add the message there

  • ah, put the full command too, is giving error in the view body, in the select part probably

  • What is the version of Postgresql? Remembering that the CREATE MATERIALIZED VIEW is only available after 9.3 https://www.postgresql.org/docs/9.3/static/sql-creatematerializedview.html

No answers

Browser other questions tagged postgresql view

You are not signed in. Login or sign up in order to post.