pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres Doubt
2+ messages / 2 participants
[nested] [flat]
* Postgres Doubt
@ 2004-09-28 03:27 sreejith s <getsreejith@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: sreejith s @ 2004-09-28 03:27 UTC (permalink / raw)
To: pgsql-sql-owner@postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres Doubt
@ 2004-10-03 15:50 John DeSoi <desoi@pgedit.com>
parent: sreejith s <getsreejith@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: John DeSoi @ 2004-10-03 15:50 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-10-03 15:50 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-28 03:27 Postgres Doubt sreejith s <getsreejith@gmail.com>
2004-10-03 15:50 ` John DeSoi <desoi@pgedit.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox