Thread: Win32 Client Tools

Win32 Client Tools

From
"Dan Hoover"
Date:
Are there any Win32 client tools for interacting with PostgreSQL?  Are they
version specific v7, v6?

Thanks
Dan


Re: Win32 Client Tools

From
"Rob Arnold"
Date:
Check out Pg_Access at www.greatbridge.org

You can also use Access (or whatever) & ODBC.

--rob



----- Original Message -----
From: "Dan Hoover" <dan@hooversys.com>
To: <pgsql-novice@postgresql.org>
Sent: Monday, February 19, 2001 4:45 PM
Subject: Win32 Client Tools


> Are there any Win32 client tools for interacting with PostgreSQL?  Are
they
> version specific v7, v6?
>
> Thanks
> Dan
>
>


selecting using WHERE on arrays

From
Adam Lowry
Date:
Hello, I'm getting ramped up on pgsql, and so far the documentation has
helped wonderfully on everything but this problem.

Is it possible to perfom a select query where that will return any row that
contains a particular value in an attribute array? That does't sound very
clear. What I'm trying to do is something like this (to use a music album
analogy):

in a table ALBUM we'd have:
name text, etc
artist integer[] - where these integers are foreign keys into the artist
table.

what I'd like to do is:
select * from album where <artist index X is in artist array>;

Is this possible? All I've been able to do so far is select where a value = a
particular entry in the array ( [0] for example). Am I thinking about this
all wrong?

Thanks, Adam