Thread: Please Help me

Please Help me

From
jairo emilio ortiz romero
Date:
I want to know if exists a limit ind the number of
lines of a function, I wrote a function in pgaccess
but when I use the PgAdmin I only see a part of them,
I would like to know if there is a command to see the
script of creation of a function. Thank you very much
for your answer.



__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

Re: Please Help me

From
"Steve Boyle \(Roselink\)"
Date:
Jairo,

1.    I'd recommend storing the SQL / function creation scripts in a file
before running the code.
2.    You can use the pg_dump command to output all of the database and then
pull the function definitions from the dump file (see
http://www.postgresql.org/idocs/index.php?backup.html)

hih

sb

----- Original Message -----
From: "jairo emilio ortiz romero" <jairoortiz_55@yahoo.com>
To: <pgadmin-support@postgresql.org>
Sent: Tuesday, January 08, 2002 4:32 PM
Subject: [pgadmin-support] Please Help me


> I want to know if exists a limit ind the number of
> lines of a function, I wrote a function in pgaccess
> but when I use the PgAdmin I only see a part of them,
> I would like to know if there is a command to see the
> script of creation of a function. Thank you very much
> for your answer.
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>