I need to add a column to a table. This table holds several thousand
records, has several indexes, and serves as the parent table to a few
child tables.
When I've done this in the past, it has taken quite a long time for
the ALTER TABLE command to complete.
So, what is the correct procedure for
Thanks to Alvaro H. and Joshua D. for pointing me to pg_proc.
The function I was looking for is an overloaded one, so in my query of
pg_proc I had to specify the signature of the one that I wanted.
My favorite page, for today:
http://www.postgresql.org/docs/7.3/static/catalogs.html
-David
> Whe
Where are PL/pgSQL functions stored? I want to retrieve the text of a
function that I've created.
Thanks.
-David
---(end of broadcast)---
TIP 8: explain analyze is your friend
I've created two PL/pgSQL functions with the same name and different
signatures:
CREATE FUNCTION ABC(CHAR) ...
CREATE FUNCTION ABC(TEXT)
I intended to call the CHAR-signature function like this:
SELECT ABC('R');
And the TEXT-signature function like this:
SELECT ABC('Right');
But I found th
