INSERT for inherited tables

Поиск
Список
Период
Сортировка
От Lewis Bergman
Тема INSERT for inherited tables
Дата
Msg-id 200203291817.g2TIHvO10056@lewis.abi.tconline.net
обсуждение исходный текст
Ответы Re: INSERT for inherited tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Dave Dartnall
Дата:
Сообщение: Formatted printing output
Следующее
От: Tom Lane
Дата:
Сообщение: Re: INSERT for inherited tables