PostgreSQL 9.3 Amazon RDS gives error while using UUID-OSSP extension for generating uuid
You appear to be attempting to load uuid-ossp extension by loading the .sql file directly. You should not be doing that on any modern PostgreSQL, and it won't work on RDS.

Use

CREATE EXTENSION "uuid-ossp";


instead.