A while back, I thought I remembered seeing a Mac OS X client for PostgreSQL
which had a feature where it would display a graphic schema of whatever
database you connect to but I can't seem to find it again (web searching.)I
did come across one post which said that this was a planned feature
Thanks, each of you for all the suggestions on schema generating tools. I
haven't had a chance to evaluate them all yet but DBVisualizer looks pretty
good. In the meanwhile I found SQL Power Architect, which is also free/open
source, and can do this kind of diagraming but is not as good as DBV
Thanks, each of you for all the suggestions on schema generating tools. The
idea is to have something which will connect to the database and automatically
make a schema from what you've got. Here's what I have had a chance to
evaluate so far...
DBVisualizer - It does a good job with the defau
On Nov 11, 2010, at 4:56 PM, Thomas Kellerer wrote:
>
> Actually I think it would be worthwhile documenting your experience in the
> PostgreSQL Wiki as well:
>
> http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
Thanks, I will post something there after I have done some m
I have a table where I should have declared a foreign key with ON UPDATE
CASCADE and didn't. Now I want to fix that. From the documentation on
www.postgresql.org, about ALTER TABLE it's not at all clear how to do this or
even whether you can do this.
-Aram
--
Sent via pgsql-general mailing
On Nov 17, 2010, at 12:42 PM, Richard Broersma wrote:
> ALTER TABLE foo
> DROP CONSTRAINT your_constraint,
> ADD CONSTRAINT your_constraint FOREIGN KEY ...
> ON UPDATE CASCADE ON DELETE RESTRICT;
Thanks. That worked.
-Aram
--
Sent via pgsql-general mailing list (pgsql-general@pos
also
appear as "acetaminophen, aspirin" and I want these grouped together in the
query. Is there a simple way to do this?
--Aram Fingal
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> Easy way is something like
>
> SELECT LEAST(drug1, drug2), GREATEST(drug1, drug2), AVG(response)
> FROM data
> GROUP BY 1, 2
>
> though it'd be a PITA to scale that to more than 2 drugs.
>
> regards, tom lane
Thanks, Tom and Hubert, who said the same thing. For the for
I just tried to set up a PostgreSQL server on an existing instillation of
Ubuntu 13.10 server but I am getting an error trying to start the server and I
am not finding anything relevant to the error searching the web.
Here’s what I did to install:
$ sudo apt-get install postgresql
$ sudo apt-ge
>
> "listen_addresses='*'" parameter doesn't belong in pg_hba.conf
>
> This parameter should be in postgresql.conf
Thanks. That was really unclear, at least the way I followed the online
documentation:
http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html
…even after following th
I want to create a user defined data type but have flexible input just like,
for example, the boolean data type where TRUE can be entered as any of (TRUE,
true, T, t, YES, yes, Y, y, 1...) and it will be interpreted as the same thing.
So suppose I have days of the week:
CREATE TYPE days_of_
I want to set up a new PostgreSQL database from an XML database file. It seems
like there should be an obvious way to do this but I can't seem to find any
directions anywhere. How is this sort of thing normally done?
The database is available to the public here:
http://www.drugbank.ca/downloa
>
> a generic ETL (extract, transform, load) tool that supports XML and
> postgresql should be able to do it, but its not something built into
> postgresql as-is.I can't recommend any specific ETL tool to do this as
> I've never needed to do this exactly.
Thanks. That at least tells me th
I have a field which contains an interval value and I sometimes need to
represent the full interval (not a part) as a decimal number of months. For
example, "5 years 6 mons 3 days" as "66.1 months". I've been trying to figure
out how to do this and haven't found a definitive answer.
The fol
t's
as much accuracy as I need. I don't even know the exact standard used by the
source for a month, though I could ask if it becomes an issue.
-Aram Fingal
Has anyone tried developing a PLR procedure to do the equivalent of crosstab
but using the Reshape library from R? The reason I ask is that I have been
extracting tables like this with an R script, using RPostgreSQL, then functions
from Reshape and writing the output to a .csv file. I wonder i
On Sep 4, 2012, at 2:51 PM, Vincent Veyron wrote:
> Le mardi 04 septembre 2012 à 08:39 -0700, punnoose a écrit :
>> hi all
>> How could i use crostab to display variable number of columns. in the output
>> There could be variable number of columns
>
> see the documentation for Additional Supplie
On Sep 4, 2012, at 3:26 PM, Joe Conway wrote:
> On 09/04/2012 12:17 PM, Aram Fingal wrote:
>> On Sep 4, 2012, at 2:51 PM, Vincent Veyron wrote:
>>> see the documentation for Additional Supplied Modules, in your
>>> case tablefunc :
>>>
>>&
On Sep 4, 2012, at 3:56 PM, Joe Conway wrote:
> On 09/04/2012 12:48 PM, Aram Fingal wrote:
>> So, are you saying that if I do something like this:
>>
>> copy(crosstab(source_sql, category_sql)) to '/output.csv' with csv;
>>
>> Then I don't ha
On Sep 4, 2012, at 4:18 PM, Misa Simic wrote:
> Inside PL/R you can take the same table as it is (unpivoted) as your
> data.frame and then pivot it inside R using reshape package,,, And then
> inside PL/R function do whatever you would like to do with data i.e export to
> whatever... - but you
On Sep 4, 2012, at 4:36 PM, A.M. wrote:
> Or you could return the heatmap/plot as BYTEA data or use arrays as necessary.
I was actually thinking exactly the same thing. Part of the reason I use
PostgreSQL for all my bioinformatics work is that there is a need to correctly
associate analysis r
I have a table which currently has about 500 million rows. For the most part,
the situation is going to be that I will import a few hundred million more rows
from text files once every few months but otherwise there won't be any insert,
update or delete queries. I have created five indexes, so
On Sep 6, 2012, at 5:54 PM, Tom Lane wrote:
> That sounds like you lack an index on the referencing column of the
> foreign key constraint. Postgres doesn't require you to keep such
> an index, but it's a really good idea if you ever update the referenced
> column.
Thanks. You're right. That
On Sep 7, 2012, at 11:15 AM, Marti Raudsepp wrote:
> There's a pg_bulkload extension which does much faster incremental
> index updates for large bulk data imports, so you get best of both
> worlds: http://pgbulkload.projects.postgresql.org/
Thanks, I'll have to check that out. This is going t
I'm working with some people who live and breath Excel. I need to be able to
move data back and forth between formats which make sense for Excel and for
PostgreSQL. In some cases, this is just to accommodate what people are used
to. In other cases, like statistical clustering, it's something
On Sep 16, 2010, at 12:28 PM, Sam Mason wrote:
> On Thu, Sep 16, 2010 at 11:42:21AM -0400, Aram Fingal wrote:
>> create table results(
>> expt_no int references experiments(id),
>> subject int references subjects(id),
>> drug text references drugs(name),
>>
On Sep 16, 2010, at 4:37 PM, John R Pierce wrote:
> On 09/16/10 10:44 AM, Aram Fingal wrote:
>> I have thought about that but later on, when we do the full sized
>> experiments, there will be too many rows for Excel to handle.
>
> if you insist on this transposing, won&#
On Sep 17, 2010, at 9:00 AM, Steve Clark wrote:
> I think excel 2007 can handle more than 65,535 rows.
You may be right. I'm actually using NeoOffice (Mac enhanced version of
OpenOffice) and that can handle something like 1,048,000 rows.I wouldn't be
surprised if newer versions of Excel c
I'm using the OS X precompiled binary from EnterpriseDB and want to add the
tablefunc contrib module. I haven't been able to find any documentation about
how to do this or even whether modules can be added to this binary version.
I suppose that it may be a good idea to export my databases and
On Sep 20, 2010, at 2:12 PM, Dave Page wrote:
> On Mon, Sep 20, 2010 at 7:06 PM, Aram Fingal
> wrote:
>> I'm using the OS X precompiled binary from EnterpriseDB and want to add the
>> tablefunc contrib module. I haven't been able to find any documentation
>
30 matches
Mail list logo
