INSERT for inherited tables

From: Lewis Bergman <lbergman(at)[nospam] abi(dot)tconline(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: INSERT for inherited tables
Date: 2002-03-29 18:17:57
Message-ID: 200203291817.g2TIHvO10056@lewis.abi.tconline.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

In the manual in the inherited section there is no mention or an example of
how to do an insert into such a table. It also isn't addressed in the insert
section. Undoubtedly this means everyone else is perfectly clear on the
subject. Alas, I am not.

How would one go about that?
Is it something on the order of
INSERT INTO capitals (state) VALUES ('Wisconson')
WHERE cities.name = 'Madison';
Or can you somehow do the entire insert in one shot?
--
Lewis Bergman
Texas Communications
4309 Maple St.
Abilene, TX 79602-8044
915-695-6962 ext 115

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message thiemo 2002-03-30 02:02:26 CURRENT_USER
Previous Message denis 2002-03-28 05:07:12 Re: Export query result to text file?