Re: simple select question - Mailing list pgsql-general

From Ragnar
Subject Re: simple select question
Date
Msg-id 1180950627.5953.2.camel@localhost.localdomain
Whole thread Raw
In response to simple select question  ("Erol KAHRAMAN" <erol.kahraman@gmail.com>)
List pgsql-general
On mán, 2007-06-04 at 12:12 +0300, Erol KAHRAMAN wrote:
> hi guys,
>
> i am newbie in postgresql.  I need some help; i am trying to write
> like this:
>
> select * from TABLE where IN ('value1','valeue2',....)

... WHERE what IN (...) ?

> but is it possible to give values from file.
>
> select * from TABLE where IN file

not really. you'd have to import your file
into a table first, possibly with COPY.

gnari



pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: simple select question
Next
From: Martijn van Oosterhout
Date:
Subject: Re: changing 'mons' in interval?