Thread: Postgres Doubt

Postgres Doubt

From

sreejith s

Date:

03 October 2004, 18:27:40

Hello,     I am new to PostgreSQL. I have a doubt. Now i am doing one
project in .NET technology with postgres(linux) as database. I am
using pgADMIN and pgManager as tools for database releted activities.
Now i am able to create functions with 'sql' language. When i select
'pgsql' as language for creating query, an error poping up. How to
create Query using 'pgsql' language. if any new tools need to be
installed. Plz rectify. Mail me back at sreejith77@rediffmail.com

Sreejith

Re: Postgres Doubt

From

John DeSoi

Date:

03 October 2004, 19:52:07

On Sep 27, 2004, at 11:27 PM, sreejith s wrote:

> Hello,
>       I am new to PostgreSQL. I have a doubt. Now i am doing one
> project in .NET technology with postgres(linux) as database. I am
> using pgADMIN and pgManager as tools for database releted activities.
> Now i am able to create functions with 'sql' language. When i select
> 'pgsql' as language for creating query, an error poping up. How to
> create Query using 'pgsql' language. if any new tools need to be
> installed. Plz rectify. Mail me back at sreejith77@rediffmail.com
>
>

You need to use the createlang utility to add pgsql to your database.

see
http://www.postgresql.org/docs/current/interactive/app-createlang.html
http://www.postgresql.org/docs/current/interactive/sql- 
createlanguage.html

You generally want to do this for template1 so it will be available in  
any new database you create.

Best,


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL