dynamic table/col names in plpgsql - Mailing list pgsql-general

From gary jefferson
Subject dynamic table/col names in plpgsql
Date
Msg-id 62ad745a0706232043i49de3d50s948374be309e56b2@mail.gmail.com
Whole thread Raw
Responses Re: dynamic table/col names in plpgsql  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Is there a way to use a variable as the name of a table or column in plpgsql?

This might be a simple question, but I can't find the answer in the
docs.  http://www.postgresql.org/docs/8.2/interactive/plpgsql-declarations.html
hints that there are data types that correspond to table/column, but I
don't see them listed here
http://www.postgresql.org/docs/8.2/interactive/datatype.html ...

Also, I assume that once I figure out the right datatypes, I can
assign to them from functions like substring()?

Thanks,
Gary

pgsql-general by date:

Previous
From: daniel65456@gmail.com
Date:
Subject: Duplicate records returned
Next
From: cha
Date:
Subject: problem importing data with psql