On 17 February 2010 13:02, Krzysztof Walkiewicz <bars0(at)op(dot)pl> wrote:
> Hi everybody!
> I try to insert data from one table to another with:
> INSERT INTO L_klienci_wysylka ('id_klienta','data_wys')(SELECT
> 'ID','data_wys' FROM 'I_klienci')
> but I get:
> 4: Table not found in statement [INSERT INTO L_klienci_wysylka]
> I'm sure that table L_klienci_wysylka exist because I can enter the data
> I am using OpenOffice Base 3.2.0 with HSQL engine.
> I know that this is PostgreSQL mailing list, but I can't get the answer from
> OOBase mailing list.
You've specified the table in the select statement as a value. Remove
the single quotes.
In response to
pgsql-novice by date
|Next:||From: Thom Brown||Date: 2010-02-17 13:43:20|
|Subject: Re: Inserting data from one table to another|
|Previous:||From: Krzysztof Walkiewicz||Date: 2010-02-17 13:02:48|
|Subject: Inserting data from one table to another|