similar to: PostgreSQL database design tool

Hi, I recently bought by first Mac and I''m looking for some alternatives for my windows applications. Does anybody know a decent gui admin app for postgresql? On windows I use postgresql manager: http://www.sqlmanager.net/en/products/postgresql/manager I find this a very good piece of software and it''s free, even though I paid a little for some extra features. I''d

Hi, Use ?split() #dat1 is the dataset: lst1<- split(dat1,dat1$BaseProd) lst1 #$`2231` ?# BaseProd? CF OSA #1???? 2231 0.5 0.7 #2???? 2231 0.8 0.6 #3???? 2231 0.4 0.8 # #$`2232` ?# BaseProd CF OSA #4???? 2232? 1?? 2 #5???? 2232? 3?? 1 # #$`2233` ?# BaseProd? CF OSA #6???? 2233 0.9 0.5 #7???? 2233 0.7 0.5 #8???? 2233 4.0 5.0 #9???? 2233 5.0 7.0 lst1[[1]] #? BaseProd? CF OSA #1???? 2231 0.5 0.7

I did chmod -R 777 /var/lib/dovecot and it worked. I just need to figure out what the correct setting are. Thanks everyone //Ger ----------------original message----------------- From:Ger Hooton Scoil Chro? ?osa Blarney [ghooton at scins.ie ] To:Robert Moskowitz [rgm at htt-consult.com ], chaouche yacine [yacinechaouche at yahoo.com ], dovecot at dovecot.org Date:Tue, 21 Mar 2017 14:05:17

Hello List, I would like to connect to a postgreSQL database on a remote server and I am wondering what is the best package to do that. I have just installed RpgSQL, RPostgreSQL, Rdbi and RODBC. The handiest to me is RPostgreSQL but I don't see how to connect to a remote server with it. For sure I can connect to remote server with RODBC, but since I am on a Mac OSX 10.6, I have quite

Hi, I recently migrated from Windows to Linux. I´ve used Linux quite a bit in server-enviroments, but as a desktop I have very little experience. I am now looking for a tool to rip CD´s to Ogg with CDDA support. I´ve tried KonCD, but it lacks features and is abit buggy. Sure, I can use cdparanoia, rename the wav´s to the right names and then encode to ogg via oggenc. But since I use X I

Hello all, I am curious about what tools you guys use to make your databases. I know David uses CocoaMySQL. Are there other tools for other platforms and for other databases? I''m not very good with the SQL language, so I would like being able to do all my database setup with an easy-to-use tool (defining tables, fields, primary keys, foreign keys, indexes, etc.) Big kisses, Vincent.

I searched the list archives and I found one answer to this which suggested I should install the PG yum repos. I don't like that answer for reasons which follow. I'm running Centos 6.0 freshly installed, and I've decided that with this box I'm sticking as much as possible to just the CentOS repos that go with that release. I figure in particular I do not need any PG features

Is there any reason to avoid using postgresql for small web apps? That is, is it''s overhead so large that the lighter MySQL will work substantially better for small apps on small machines? Or are they very similar in performance and configuration? I''ve used MySQL but postgresql has its appeals and I''m wondering if I need to keep MySQL around at all. On the other

I have a data set with the following structure (with many more obs.): var1 expt day diameter 1 1 2 0.5 1 1 3 0.9 1 1 4 1.3 1 1 5 1.7 1 2 2 0.3 1 2 3 0.5 1 2 4 0.9 1 2 5 1.6 2 1 2 0.7 2 1 3 1.2 2 1 4 1.6 2 1 5 2.3 2 2 2 0.4 2 2 3 0.8 2 2 4 1.6 2 2 5 3.2 I can get separate regression analysis for each level of var1 and expt with the command: by(data3, data3$var1:data3$expt, function(x)

Anyone been able to get pgadmin3 installed on CentOS-4 ? The WxGTK2 stuff makes it impossible for me to get installed from RPM/SRPM from their site and likewise, couldn't rebuild from Fedora SRPMS either. I figure between Jim and Owen and ???, somebody might have succeeded where I would be doomed. I can get around with phppgadmin but pgadmin3 is pretty cool. Thanks Craig

If I select my date column from the pgadmin I see that in the ddmmyyyy form, I''ve specified so in the postgresql config. When I query from rails I get the date in yyyymmdd someone knows why? Thanks Enrico -- "The only thing necessary for the triumph of evil is for good men to do nothing" Edmund Burke

Hi, I have these vectors: > WEEK <- rep(c(1:52),2) > YEAR <- rep(c(2000,1999),c(52,52)) How to make a vector of Date with weeks in years? I try as.date from survival package, but it dont work with weeks, just only with days, months etcs. Thanks Ronaldo -- "Realmente minha cidade e muito facultativa" --Elivelton, ao rep?rter da Jovem Pan que falava das muitas

Hi, I have the follow function: function() { ## Init of function ... for(i in test) { ... while(j <= test2) { ... } } } The problem is that sometimes, naturally, the while is not possible to be resolved, and so the program abort. In this case I need that program return to the init of function and run again. How I can make this? Abort the while, abort the for

Hi, I have some data that have this behaviour: | |******* | * | * | * | * |---------------- What is the best and simpler way to fit this in R? Thanks Ronaldo -- Ela pilotava um Continenal 2001 com igni????o autom??tica Magiclic... -- |> // | \\ [***********************************] | ( ?? ?? ) [Ronaldo Reis J??nior ] |>

I've been fighting to get the latest source of pgadmin compiled on Centos 5 64-bit. I obtained gnu-c++ (so it was happy with g++). It then complained about wxWidgets, so I obtained the source for that, compiled and installed, and ./configure for pgadmin saw wxWidgets and was happy with that. Go to make... It complains that some header file is missing. A google search reveals limited

Hi, Creating a new Rails application with -d postgresql sets the encoding in the database.yml to unicode Creating a new Rails with -d mysql sets the encoding to utf8 Any ideas why this difference? I''ve been having problems with encoding due to localization, accents, json and what no. I thought I was using utf8 and not unicode. Would this have any impact? If this would be an issue?

I'm use RPostgreSQL to access data on a Postgres server. I would like to keep my SQL statements in external files, as they're easier to write and debug in pgAdmin, then I use readLines to bring them into R and feed to dbGetQuery. Here's the problem. When I create a SQL script with pgAdmin, then load it in R, the ensuing script fails when I feed it to dbGetQuery. When I inspect the

Is it possible for two PDA's to communicate like telephones via SIP channels on a PC running Asterisk? If that is possible, does there exist any applications that can be installed on a Zaurus 5600, which is a PDA with an Xscale processor running on a Linux OS, that can essentially turn it into a softphone? Thanks in advance for any input, Daniel

Hi All, I cannot get the sieve_before to work. I have dovecot & sieve installed on Debian 7 as follows /etc/dovecot/conf.d/90-sieve.conf : plugin { # The path to the user's main active script. If ManageSieve is used, this the # location of the symbolic link controlled by ManageSieve. sieve = ~/.dovecot.sieve # The default Sieve script when the user has none. This is a path to a

Hi, exist in R any glmm function that have any tools for test for overall goodness of fit? Thanks Ronaldo -- O papel da impressora ? sempre mais forte na parte picotada. -- | // | \\ [***********************************] |> ( ? ? ) [Ronaldo Reis J?nior ] | V [UFV/DBA-Entomologia ] |> / \ [36571-000 Vi?osa - MG ] |