Thread: problem in plpgsql

On Jul 2, 2007, at 0:00 , saumya goel wrote:

> i am stuck on a problem in plpgsql where in i have to take the
> values from
> user through keyboard. these values are to be stored in a
> particular row and
> have to be operated on by a trigger. currently i am not able to
> find what
> command works in plpgsql what "scanf" works in c

Generally people will write a user interface (such as a web or gui
application) using another language or environment that connects to
the database. PL/pgSQL (and the other procedural languages) are for
code that works primarily within the database and doesn't really have
the functionality you describe. Your users could use a pre-built
client such as psql, pgAdmin, or phpPgAdmin if you don't need
something specialized for your specific needs.

Michael Glaesemann
grzm seespotcode net