Re: [SQL] postgreSQL editors
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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
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
Re: [SQL] sort by on two columns
Sounds like you may want to concatenate the columns: ... order by table1.name || table2.name The sorting would then be performed on both of the them as though they were one column. Adam Ruth On Jan 2, 2004, at 8:04 PM, Michael Glaesemann wrote: On Jan 2, 2004, at 8:55 PM, Andy Lewis wrote: Yes, I understand this but, I would like to have the results of both "table1.name, table2.name" sorted as one column. Is this possible? So you want one column of name, including names from both table1 and table2? In that case, you need to use UNION, I believe. If it's something else, I'm not sure I understand what you're asking. Perhaps you could include a sample of what you're getting, along with what you'd like to see? Michael Glaesemann grzm myrealbox com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [SQL] perfomance question
On Mar 18, 2004, at 11:27 PM, sad wrote: On Thursday 18 March 2004 21:38, you wrote: Sad, what are perfomance difference bitween a) update t1 set f1 = 'x', f2 = 'y'; b) update t1 set f1 = 'x', f2 = f2; c) update t1 set f1 = 'x'; ? Not a lot. Why don't you try it? Really ! why ? :-) I forgot to ask the second question: How these updates affect a data storage ? (does (b) cause physical update of f2 ?) Updates always apply to full rows at a time. So while "update t1 set f1 = 'x'" only changes the value of f1 to 'x', f2 will have a second copy with the same value in the new row that is created as part of the update. It's all part of the MVCC architecture. There may be some uncommon exceptions to this rule, but I'm not sure. Adam Ruth ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[SQL]
-- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Comparing two tables of different database
The simple answer is to pg_dump both tables and compare the output with diff. Other than that, I think you'll need a custom program. On 29/04/2009, at 10:33 PM, Pawel Socha wrote: 2009/4/29 Nicholas I : Hi, can anybody me suggest me, how to compare two tables of different database. -Nicholas I what you mean 'different database' :) diffrent version, 2 instance ? Maybe this help: http://www.postgresql.org/docs/current/static/dblink.html -- Pawel Socha -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
