From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alexander Farber Sent: Monday, March 21, 2016 10:43 AM To: pgsql-general <pgsql-general@postgresql.org> Subject: [GENERAL] Including SQL files
Hello fellow pgsql users,
I am programming a word game backend in PL/pgSQL and have already reached a point, where (too) many stored functions are declared in a single file words.sql:
# SELECT proname || '(' || oidvectortypes(proargtypes) || ')' FROM pg_proc INNER JOIN pg_namespace ns ON (pg_proc.pronamespace = ns.oid) WHERE ns.nspname = 'public' ORDER BY proname; ?column? ----------------------------------------------------------------- test1(integer) words_hash(character varying) words_join_new_game(integer, integer) words_merge_users(jsonb, inet) words_paying_user(integer) words_play(integer, integer, jsonb) words_shuffle(character varying[]) words_skip_game(integer, integer) words_surrender_game(integer, integer) words_swap_game(integer, integer, character varying) words_trigger() words_valid_user(integer, character varying, character varying) (12 rows)
I would prefer to have every stored function in a separate file (which would make reading git history easier too) and include them from words.sql.
Is there such a thing for PostgreSQL 9.5.1 available please and if not - could you share your approaches here?