Re: [GENERAL] Tool to create database diagrams in postgreSQL

2012-12-29 Thread Wolfgang Keller
> Can anyone tell me which free GUI based tools are available for > creating database diagrams for my database in postgresql. One standard answer to this frequently asked question is: http://www.databaseanswers.org/modelling_tools.htm Sincerely, Wolfgang -- Sent via pgsql-general mailing lis

[GENERAL] do I need a table function to do this?

2012-12-29 Thread Kirk Wythers
I have been given an interesting problem to solve in a postgres db. I was given two tables t1: sitetreatment variableid (pk) - A X BLUE1A

[GENERAL] do I need a table function to do this

2012-12-29 Thread Kirk Wythers
I have been given an interesting problem to solve in a postgres db. I was given two tables t1: sitetreatment variableid (pk) - A X BLUE1A

Re: [GENERAL] do I need a table function to do this?

2012-12-29 Thread Serge Fonville
Hi, Assuming the columns in t2 are fixed, you should be able fairly easy solve this using a cursor. HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in SQL Server https://connect.microsoft.com/SQLServer/

Re: [GENERAL] do I need a table function to do this

2012-12-29 Thread Bryan Lee Nuse
Hello Kirk, Is this even possible? It looks like if you could "un-pivot" your t2, then you could do a join between that result and t1 and have your desired table. Others may be able to suggest a more direct solution, but I've successfully adapted the one given here, with my own wide-format

Re: [GENERAL] Installing pgAgent with MS Windows

2012-12-29 Thread terenceng
After a quick search in the forum (i find that I can install it via application stack builder). Anyway, this forum is good, i just hope there is better documentation in the official website in the future. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Installing-pgAgen

Re: [GENERAL] Installing pgAgent with MS Windows

2012-12-29 Thread terenceng
I am facing exactly the same problem, anyone has procedure for installing pgAgent in Windows? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Installing-pgAgent-with-MS-Windows-tp5729563p5738179.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.