Re: problem in plpgsql

From: Michael Glaesemann
Subject: Re: problem in plpgsql
Date: ,
(view: Whole thread, Raw)
In response to: problem in plpgsql  ("saumya goel")
List: pgsql-novice

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

pgsql-novice by date:

From: Tom Lane
Subject: Re: Schema Problem
From: "Ashish Karalkar"
Subject: On_error_stop