There is no clean way to extract defaults values for postgres stored procedure parameters. information_schema.parameters lists parameter information but not default values SELECT * FROM ...