Including SQL files
От | Alexander Farber |
---|---|
Тема | Including SQL files |
Дата | |
Msg-id | CAADeyWjJoUpFhgCFop0_Z06G3a78xfXrH_O=b4fo5AZmzaO6Kw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Including SQL files
Re: Including SQL files Re: Including SQL files Re: Including SQL files |
Список | 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)
В списке pgsql-general по дате отправления: