Re: problem in plpgsql

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: saumya goel <somya(dot)goel(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem in plpgsql
Date: 2007-07-02 13:41:59
Message-ID: 8DFA18C2-A45A-497A-9084-2D10EFEB4A9B@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-07-02 15:12:24 Re: Schema Problem
Previous Message John DeSoi 2007-07-02 12:14:10 Re: Schema Problem