Table name as variable parameter

Question

I made a function in pgadmin

create or replace function get_source2(a text)
returns integer as
$$
declare
    a text;
    geom geometry;
begin
    select get_source(geom) 
    from a;
end;
$$
language plpgsql;

I want input a by table name How can I do? I try to like this

select get_source2('postgis.center')

but I get:

ERROR: relation "a" does not exist LINE 2: from a help me

Vao Tsun · Accepted Answer · 2016-11-29 10:25:02Z

1

try this:

create or replace function get_source2(a text)
returns integer as
$$
declare
    geom geometry;
begin
  execute 'select get_source(geom) from '||quote_ident(a) into geom;
  return geom;
end;
$$
language plpgsql;

edited Nov 29, 2016 at 10:25

user1804599

answered Nov 29, 2016 at 10:22

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Table name as variable parameter

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related