| Lists: | pgsql-novice |
|---|
| From: | "saumya goel" <somya(dot)goel(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | problem in plpgsql |
| Date: | 2007-07-02 05:00:34 |
| Message-ID: | 888154f50707012200t22bb1334vae449849d823a040@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
hi,
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
i would be glad to find any help on this...
thanks
saumya
| 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 |
| 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