pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgreSQL editors
8+ messages / 6 participants
[nested] [flat]
* postgreSQL editors
@ 2003-12-30 16:05 beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-30 16:53 ` Re: postgreSQL editors Adam Ruth <aruth@intercation.com>
2003-12-31 05:02 ` Re: postgreSQL editors Michael Glaesemann <grzm@myrealbox.com>
0 siblings, 2 replies; 8+ messages in thread
From: beyaRecords - The home Urban music @ 2003-12-30 16:05 UTC (permalink / raw)
To: pgsql-sql
Hi,
can anyone recommend a good editor for postgreSQl wich wil enable me to
create functions/stored procedures?
I am currently running version 7.4.1 on OS X 10.3
regards
Uzo
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgreSQL editors
2003-12-30 16:05 postgreSQL editors beyaRecords - The home Urban music <uzo@beya-records.com>
@ 2003-12-30 16:53 ` Adam Ruth <aruth@intercation.com>
1 sibling, 0 replies; 8+ messages in thread
From: Adam Ruth @ 2003-12-30 16:53 UTC (permalink / raw)
To: beyaRecords - The home Urban music <uzo@beya-records.com>; +Cc: pgsql-sql
I currently use XCode from Apple (their free development environment).
I create sql scripts which I then either execute directly in psql or
copy and paste into an open psql session for small changes.
On Dec 30, 2003, at 9:05 AM, beyaRecords - The home Urban music wrote:
> Hi,
> can anyone recommend a good editor for postgreSQl wich wil enable me
> to create functions/stored procedures?
> I am currently running version 7.4.1 on OS X 10.3
>
> regards
>
> Uzo
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgreSQL editors
2003-12-30 16:05 postgreSQL editors beyaRecords - The home Urban music <uzo@beya-records.com>
@ 2003-12-31 05:02 ` Michael Glaesemann <grzm@myrealbox.com>
2003-12-31 15:23 ` Re: postgreSQL editors Wei Weng <wweng@kencast.com>
2003-12-31 19:08 ` Re: postgreSQL editors Rich Hall <rhall@micropat.com>
1 sibling, 2 replies; 8+ messages in thread
From: Michael Glaesemann @ 2003-12-31 05:02 UTC (permalink / raw)
To: beyaRecords - The home Urban music <uzo@beya-records.com>; +Cc: pgsql-sql
On Dec 30, 2003, at 10:05 AM, beyaRecords - The home Urban music wrote:
> Hi,
> can anyone recommend a good editor for postgreSQl wich wil enable me
> to create functions/stored procedures?
> I am currently running version 7.4.1 on OS X 10.3
If you're looking for an editor to write arbitrary SQL and support
color syntax highlighting, you probably can't go wrong with BBEdit. You
can get the ANSI SQL glossary for highlighting, and although it won't
pick up PostgreSQL-specific extensions to SQL, it will highlight the
majority of the syntax. Also has great grep (including savable search
patterns), Applescript, FTP, CVS, and shell script support, if those
things interest you. I write most of my SQL in it before feeding the
file to psql or just copying and pasting the commands into phppgadmin
or psql directly.
Michael Glaesemann
grzm myrealbox com
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgreSQL editors
2003-12-30 16:05 postgreSQL editors beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-31 05:02 ` Re: postgreSQL editors Michael Glaesemann <grzm@myrealbox.com>
@ 2003-12-31 15:23 ` Wei Weng <wweng@kencast.com>
1 sibling, 0 replies; 8+ messages in thread
From: Wei Weng @ 2003-12-31 15:23 UTC (permalink / raw)
To: Michael Glaesemann <grzm@myrealbox.com>; +Cc: beyaRecords - The home Urban music <uzo@beya-records.com>; pgsql-sql
Michael Glaesemann wrote:
>
> On Dec 30, 2003, at 10:05 AM, beyaRecords - The home Urban music wrote:
>
>> Hi,
>> can anyone recommend a good editor for postgreSQl wich wil enable me
>> to create functions/stored procedures?
>> I am currently running version 7.4.1 on OS X 10.3
>
>
> If you're looking for an editor to write arbitrary SQL and support color
> syntax highlighting, you probably can't go wrong with BBEdit. You can
> get the ANSI SQL glossary for highlighting, and although it won't pick
> up PostgreSQL-specific extensions to SQL, it will highlight the majority
> of the syntax. Also has great grep (including savable search patterns),
> Applescript, FTP, CVS, and shell script support, if those things
> interest you. I write most of my SQL in it before feeding the file to
> psql or just copying and pasting the commands into phppgadmin or psql
> directly.
>
> Michael Glaesemann
> grzm myrealbox com
>
I would vote for emacs/vim if you only want simple stuff such as color
syntax highlighting. :) And with some emacs extension, you probably can do
much cooler stuff with it too.
Wei
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgreSQL editors
2003-12-30 16:05 postgreSQL editors beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-31 05:02 ` Re: postgreSQL editors Michael Glaesemann <grzm@myrealbox.com>
@ 2003-12-31 19:08 ` Rich Hall <rhall@micropat.com>
2003-12-31 19:57 ` Re: postgreSQL editors Andy Lewis <jumboc@comcast.net>
1 sibling, 1 reply; 8+ messages in thread
From: Rich Hall @ 2003-12-31 19:08 UTC (permalink / raw)
To: pgsql-sql
>> can anyone recommend a good editor for postgreSQl wich wil enable me
>> to create functions/stored procedures?
>> I am currently running version 7.4.1 on OS X 10.3
>
I use PG Manager from EMS Hitech. It is not free but inexpensive.
You have everything PostgreSQL-wise at your fingertips.
Ver 2.0 was just released and they are very responsive to bug reports.
Rick
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgreSQL editors
2003-12-30 16:05 postgreSQL editors beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-31 05:02 ` Re: postgreSQL editors Michael Glaesemann <grzm@myrealbox.com>
2003-12-31 19:08 ` Re: postgreSQL editors Rich Hall <rhall@micropat.com>
@ 2003-12-31 19:57 ` Andy Lewis <jumboc@comcast.net>
2003-12-31 20:44 ` Re: postgreSQL editors beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-31 22:46 ` Re: postgreSQL editors Adam Ruth <aruth@intercation.com>
0 siblings, 2 replies; 8+ messages in thread
From: Andy Lewis @ 2003-12-31 19:57 UTC (permalink / raw)
To: pgsql-sql
I would have to agree with EMS-HiTech's product also. A feature rich,
product, very responsive tech support/bug report. PGManager beats the
competition hands down.
Andy
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Rich Hall
Sent: Wednesday, December 31, 2003 1:09 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] postgreSQL editors
>> can anyone recommend a good editor for postgreSQl wich wil enable me
>> to create functions/stored procedures?
>> I am currently running version 7.4.1 on OS X 10.3
>
I use PG Manager from EMS Hitech. It is not free but inexpensive.
You have everything PostgreSQL-wise at your fingertips.
Ver 2.0 was just released and they are very responsive to bug reports.
Rick
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgreSQL editors
2003-12-30 16:05 postgreSQL editors beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-31 05:02 ` Re: postgreSQL editors Michael Glaesemann <grzm@myrealbox.com>
2003-12-31 19:08 ` Re: postgreSQL editors Rich Hall <rhall@micropat.com>
2003-12-31 19:57 ` Re: postgreSQL editors Andy Lewis <jumboc@comcast.net>
@ 2003-12-31 20:44 ` beyaRecords - The home Urban music <uzo@beya-records.com>
1 sibling, 0 replies; 8+ messages in thread
From: beyaRecords - The home Urban music @ 2003-12-31 20:44 UTC (permalink / raw)
To: pgsql-sql
Hi,
thanks for the responses to my original question. i have decided to use
phpPgAdmin for my database development.
I have created the following function:
create function GetEmployees() returns setof employee as 'select * from
employee;' language 'sql';
With phpPgAdmin you can define the top and bottom lines of your
function using the options available (Name, Arguments,
Returns,Programming language). Now the section that is throwing me at
the moment is the reyurns section. You have 2 drop down boxes, the
first enables you to select setof and the second provides you with a
long list. So basically I chosse a name for the function, provide
'text' as an argument to my function, select setof from the first drop
down box and plpgsql as my programming language. how do I set the
'employe part of the function from the drop down list? 'returns setof
xxxx, xxxx being the option i need to select from the drop down list
which is defaulted to "SET".
regards
Uzo
On 31 Dec 2003, at 19:57, Andy Lewis wrote:
> I would have to agree with EMS-HiTech's product also. A feature rich,
> product, very responsive tech support/bug report. PGManager beats the
> competition hands down.
>
> Andy
>
>
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Rich Hall
> Sent: Wednesday, December 31, 2003 1:09 PM
> To: pgsql-sql@postgresql.org
> Subject: Re: [SQL] postgreSQL editors
>
>
>
>>> can anyone recommend a good editor for postgreSQl wich wil enable me
>>> to create functions/stored procedures?
>>> I am currently running version 7.4.1 on OS X 10.3
>>
>
> I use PG Manager from EMS Hitech. It is not free but inexpensive.
>
> You have everything PostgreSQL-wise at your fingertips.
>
> Ver 2.0 was just released and they are very responsive to bug reports.
>
> Rick
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: postgreSQL editors
2003-12-30 16:05 postgreSQL editors beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-31 05:02 ` Re: postgreSQL editors Michael Glaesemann <grzm@myrealbox.com>
2003-12-31 19:08 ` Re: postgreSQL editors Rich Hall <rhall@micropat.com>
2003-12-31 19:57 ` Re: postgreSQL editors Andy Lewis <jumboc@comcast.net>
@ 2003-12-31 22:46 ` Adam Ruth <aruth@intercation.com>
1 sibling, 0 replies; 8+ messages in thread
From: Adam Ruth @ 2003-12-31 22:46 UTC (permalink / raw)
To: Andy Lewis <jumboc@comcast.net>; +Cc: pgsql-sql
I didn't notice an OS X version on their website. Do they have one?
On Dec 31, 2003, at 12:57 PM, Andy Lewis wrote:
> I would have to agree with EMS-HiTech's product also. A feature rich,
> product, very responsive tech support/bug report. PGManager beats the
> competition hands down.
>
> Andy
>
>
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Rich Hall
> Sent: Wednesday, December 31, 2003 1:09 PM
> To: pgsql-sql@postgresql.org
> Subject: Re: [SQL] postgreSQL editors
>
>
>
>>> can anyone recommend a good editor for postgreSQl wich wil enable me
>>> to create functions/stored procedures?
>>> I am currently running version 7.4.1 on OS X 10.3
>>
>
> I use PG Manager from EMS Hitech. It is not free but inexpensive.
>
> You have everything PostgreSQL-wise at your fingertips.
>
> Ver 2.0 was just released and they are very responsive to bug reports.
>
> Rick
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2003-12-31 22:46 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-30 16:05 postgreSQL editors beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-30 16:53 ` Adam Ruth <aruth@intercation.com>
2003-12-31 05:02 ` Michael Glaesemann <grzm@myrealbox.com>
2003-12-31 15:23 ` Wei Weng <wweng@kencast.com>
2003-12-31 19:08 ` Rich Hall <rhall@micropat.com>
2003-12-31 19:57 ` Andy Lewis <jumboc@comcast.net>
2003-12-31 20:44 ` beyaRecords - The home Urban music <uzo@beya-records.com>
2003-12-31 22:46 ` Adam Ruth <aruth@intercation.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