From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Including SQL files |
Date: | 2016-03-21 14:42:46 |
Message-ID: | CAADeyWjJoUpFhgCFop0_Z06G3a78xfXrH_O=b4fo5AZmzaO6Kw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
The "EXEC SQL INCLUDE" described at
http://www.postgresql.org/docs/9.5/static/ecpg-preproc.html seems to be
something different?
Regards
Alex
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2016-03-21 14:47:15 | Re: Including SQL files |
Previous Message | Adrian Klaver | 2016-03-21 14:39:25 | Re: plan not correct? |