https://www.opennet.me/openforum/vsluhforumID3/65824.html Создаем view:<br><br> CREATE OR REPLACE VIEW funcsource as<br> SELECT '--\012create or replace function ' &#124;&#124;<br> n.nspname::text &#124;&#124; '.'::text &#124;&#124; p.proname::text &#124;&#124;<br> '('::text &#124;&#124; oidvectortypes(p.proargtypes) &#124;&#124; ')\012'::text &#124;&#124;<br> 'returns ' &#124;&#124; t.typname &#124;&#124; ' as \'\012' &#124;&#124;<br> p.prosrc &#124;&#124; ' \'\012' &#124;&#124; <br> 'language \'' &#124;&#124; l.lanname &#124;&#124; ' \';\012' as func_source,<br> proname as function, nspname as schema, t.typname as rettype,<br> oidvectortypes(p.proargtypes) as args, l.lanname as language<br> FROM pg_proc p, pg_type t, pg_namespace n, pg_language l<br> WHERE p.prorettype = t.oid AND p.pronamespace = n.oid AND p.prolang = l.oid<br> AND l.lanname &lt;&gt; 'c' AND l.lanname &lt;&gt; 'internal' ;<br><br>Сохраняем исходные коды функций в файл:<br> psql -Atc "select func_source from funcsource;" &gt; functions.out<br><br>URL: http://www.sai.m https://www.opennet.me/openforum/vsluhforumID3/65824.html#1 Tue, 13 Apr 2010 11:16:30 GMT А как сделать то же самое, только для таблиц?<br>