| From: | eoghan <postgres(at)redry(dot)net> |
|---|---|
| To: | Joshua D(dot)Drake <jd(at)commandprompt(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: createlang |
| Date: | 2005-08-15 21:05:00 |
| Message-ID: | C8475F26-52E2-4D65-B516-A37C889D27AB@redry.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2005-08-15 21:08:51 | Re: createlang |
| Previous Message | James Cradock | 2005-08-15 21:03:09 | Re: createlang |