1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
create or replace function londiste.make_fqname(i_name text)
returns text as $$
-- ----------------------------------------------------------------------
-- Function: londiste.make_fqname(1)
--
-- Make name to schema-qualified one.
--
-- First dot is taken as schema separator.
--
-- If schema is missing, 'public' is assumed.
--
-- Parameters:
-- i_name - object name.
--
-- Returns:
-- Schema qualified name.
-- ----------------------------------------------------------------------
begin
if position('.' in i_name) > 0 then
return i_name;
else
return 'public.' || i_name;
end if;
end;
$$ language plpgsql strict immutable;
|
