MESSAGE Statement - Sybase SQL Anywhere to PostgreSQL Migration

In Sybase SQL Anywhere, the MESSAGE statement allows you to send a message to client or database message log.

In PostgreSQL, you can use the RAISE NOTICE statement.

Sybase SQL Anywhere:

  -- Send message to client
  MESSAGE 'Hello, ' || 'world!' TYPE STATUS TO CLIENT;

SQL Server:

  DO $$
  BEGIN  
    -- Send message to client
    RAISE NOTICE '%', 'Hello, ' || 'world!';
  END;
  $$;
  /* NOTICE:  Hello, world! */

For more information, see Sybase SQL Anywhere to SQL Server Migration.