Skip site navigation (1) Skip section navigation (2)

Re: how to test a PL/pgSQL function using pgAdmin III ?

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Charles Bai <charlesbaiusa(at)yahoo(dot)com>
Cc: postgre sql- <pgsql-novice(at)postgresql(dot)org>
Subject: Re: how to test a PL/pgSQL function using pgAdmin III ?
Date: 2005-11-23 15:26:09
Message-ID: c2d9e70e0511230726v7c762648p9099967af54f0e27@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 11/23/05, Charles Bai <charlesbaiusa(at)yahoo(dot)com> wrote:
> Hi,
>
> I created a plpgsql function in pgAdmin III and it will insert a record into
> a table. I am not ready to test it with my App. Can I test it first with
> pgAdmin III Query window? What would be the syntax to test it?
>
> My function is      myuser_insert(varchar, varchar)
>
> I tried
>
> Execute myuser_insert('mylogin_id', 'mypassword');
>
> But not working. ERROR:  prepared statement "myuser_insert" does not exist
>
> Thanks for any help.
>

use "select myuser_insert('mylogin_id', 'mypassword');" instead



--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

Responses

pgsql-novice by date

Next:From: Charles BaiDate: 2005-11-23 16:03:11
Subject: Re: how to test a PL/pgSQL function using pgAdmin III ?
Previous:From: Charles BaiDate: 2005-11-23 15:22:24
Subject: how to test a PL/pgSQL function using pgAdmin III ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group