On 15 Aug 2005, at 21:58, Joshua D. Drake wrote:
eoghan wrote:
Hello
Im trying to load plpgsql into my test db... Im wondering if
theres a way to check if its loaded... I do:
test-# createlang plpgsql test
createlang is a command line client:
bash# createlang -U postgres -P 5432 plpgsql database
What you are looking for is:
CREATE LANGUAGE.
Thanks Joshua,
I was using createlang from the command line...
eoghan-js-Computer:~ postgres$ /opt/local/bin/psql test -U postgres
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.
<etc>
test=# createlang plpgsql test
Or if loading .sql do you need the CREATE LANGUAGE in here?
Im new to this...
Thanks for you help
Eoghan
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
