Re: [SQL] SQL Developer accessing PostgreSQL

2010-03-31 Thread Jose Alarcon
Squirrel been tested. It is opensource, and is done in Java using JDBC to support many databases. It is a universal SQL client, see http://www.squirrelsql.org/ El 29/03/10 18:22, Hiltibidal, Rob escribió: SQL Developer accessing PostgreSQL I recommend Aqua Data Studio  

Re: [SQL] SQL Developer accessing PostgreSQL

2010-03-31 Thread Thomas Kellerer
Snyder, James, 29.03.2010 18:33: Hello, Is there a way to configure Oracle’s SQL Developer to access a PostgreSQL database? Thanks,Jim As others have pointed out, it's not possible. The Postgres Wiki contains a list of GUI Tools that work with Postgres:

Re: [SQL] Week to date function

2010-03-31 Thread Jasen Betts
On 2010-03-27, Hiltibidal, Rob rob.hiltibi...@argushealth.com wrote: U only 52 calendar weeks in a year... I'm almost sure that is the norm All hours have 60 minutes All weeks have 7 days All years have 12 months all else is variable. -- Sent via pgsql-sql mailing list

Re: [SQL] Capacity planning.

2010-03-31 Thread Bruce Momjian
David Harel wrote: Hi, Any way to get transaction count from the postgres daemon or any log? See the system view pg_stat_database. Also where can I find docs that can help me make a capacity plan for max 100,000 clients making around 200 transactions a day each. No idea. You should be