Skip site navigation (1) Skip section navigation (2)

Inserting data from one table to another

From: Krzysztof Walkiewicz <bars0(at)op(dot)pl>
To: pgsql-novice(at)postgresql(dot)org
Subject: Inserting data from one table to another
Date: 2010-02-17 13:02:48
Message-ID: 4B7BE8F8.9070005@op.pl (view raw or flat)
Thread:
Lists: pgsql-novice
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 
manually.
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.

Krzysztof

Responses

pgsql-novice by date

Next:From: Thom BrownDate: 2010-02-17 13:17:08
Subject: Re: Inserting data from one table to another
Previous:From: Machiel RichardsDate: 2010-02-17 10:58:33
Subject: check_postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group