Thread: PostgreSQL Features

PostgreSQL Features

From
"Bruno Almeida do Lago"
Date:

Hi,

 

I’d like to know if there is something like “insert /*+ append */ into” and materialized views (from Oracle) on PostgreSQL.

 

How can I pass hints to postgre and what hints are available?

 

 

Regards,

Bruno

Re: PostgreSQL Features

From
Bruce Momjian
Date:
Bruno Almeida do Lago wrote:
> Hi,
>
>
>
> I'd like to know if there is something like "insert /*+ append */ into"
> and materialized views (from Oracle) on PostgreSQL.

We have SELECT INTO if that helps.

You can do materialized views and use triggers or rules to keep the
materialized view current.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073