Re: simple select question

From: Ragnar <gnari(at)hive(dot)is>
To: Erol KAHRAMAN <erol(dot)kahraman(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: simple select question
Date: 2007-06-04 09:50:27
Message-ID: 1180950627.5953.2.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2007-06-04 09:54:50 Re: warm standby server stops doingcheckpointsafterawhile
Previous Message Albe Laurenz 2007-06-04 09:46:28 Re: Tablespaces