select into

Hi guys,

Am new to sql scripting so this might be a stupid question. Am getting an error while trying to do the following

SELECT INTO svc_data_rec * from svc_tbl_name where 'uid' = sub_id;

where svc_data_rec is defined as record and svc_tbl_name is a varchar that holds the name of a table and sub_id is another varchar. the error message is

ERROR: syntax error at or near "$1" at character 17
QUERY: SELECT * from $1 where 'uid' = $2
CONTEXT: PL/pgSQL function "foo" line 132 at select into variables
LINE 1: SELECT * from $1 where 'uid' = $2

where am i going wrong? it seems that the variables are not being substituted with their values correctly.

Thank you,

---------------------------------
Sponsored Link

Mortgage rates near 39yr lows. $420,000 Mortgage for $1,399/mo - Calculate new house payment