Re: [SQL] postgreSQL editors
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 ---(end of broadcast)--- TIP 8: explain analyze is your friend
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
Re: [SQL] postgreSQL editors
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rich Hall Sent: Wednesday, December 31, 2003 1:09 PM To: [EMAIL PROTECTED] 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
Re: [SQL] postgreSQL editors
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 , 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rich Hall Sent: Wednesday, December 31, 2003 1:09 PM To: [EMAIL PROTECTED] 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
Re: [SQL] postgreSQL editors
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rich Hall Sent: Wednesday, December 31, 2003 1:09 PM To: [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
