Installing PL/pgSQL on Linux

After you install PostgreSQL, initialize a database cluster, and create a database, sde user, and sde schema, you can install the PL/pgSQL language. This component is required for you to use the database with ArcSDE.

Steps:
  1. Log into psql, connecting to your new database as the sde user.
    psql agency sde
    
  2. Execute the following command:
    CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler 
    VALIDATOR plpgsql_validator;
    

11/18/2013