SELECT

    procpid,

    START,

    now() - START AS lap,

    current_query

FROM

    (

        SELECT

            backendid,

            pg_stat_get_backend_pid (S.backendid) AS procpid,

            pg_stat_get_backend_activity_start (S.backendid) AS START,

            pg_stat_get_backend_activity (S.backendid) AS current_query

        FROM

            (

                SELECT

                    pg_stat_get_backend_idset () AS backendid

            ) AS S

    ) AS S

WHERE

    current_query <> '<IDLE>'

ORDER BY

    lap DESC;

   --杀进程

   SELECT pg_cancel_backend('33746')

oracle

  Select NVL(foo,'Value is Null')

  FROM dual;

PostgreSQL

  Select coalesce(foo,'Value is Null')

oracle

  Select INSTR('Great','eat') FROM dual;

PostgreSQL

  Select POSITION('eat' IN 'great');

--PostgreSql

execute 'select count(1) from test' into v_count;

--Oracle

execute immediate 'select count(1) from test' into v_count;

open cur for execute 'select  * from xxx';

      loop

  end loop;

close cur;