INSERT for inherited tables - Mailing list pgsql-novice

From Lewis Bergman
Subject INSERT for inherited tables
Date
Msg-id 200203291817.g2TIHvO10056@lewis.abi.tconline.net
Whole thread Raw
Responses Re: INSERT for inherited tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-novice by date:

Previous
From: Dave Dartnall
Date:
Subject: Formatted printing output
Next
From: Tom Lane
Date:
Subject: Re: INSERT for inherited tables