I have a database with multiple schemas which have the same tables and views, and I want to create a procedure that creates a view from one the views in the schema.
CREATE OR REPLACE FUNCTION create_summary_view( created_view character varying, common_view character varying, schema_1 character varying, schema_2 character varying, schema_3 character varying, ... schema_x character varying, )
create_view is the view that will be created,
common_view is the view that is identical in all the schemas, and
schema_x are the list of schemas whose
common_views are being joined into
Does pl/pgsql have a syntax for indicating a variable number of parameters?
common_view and at least
one schema_x is required?
An alternative I'm considering it to pass a comma or space separated string of the schemas and use
regexp_split_to_array to break it up, but it would be good to know of variable length arguments are possible.