My schema uses table inheritance. I was presenting records to the UI
for insert/update by a defined view
CREATE VIEW monster AS SELECT * FROM
parent_table NATURAL LEFT JOIN child1 NATURAL LEFT JOIN.
Inserts and updates from the UI were to monster, which then used RULEs
to redirect the query t
tables is very useful in the domain.)
Shouldn't pg_dump do a (not yet implemented)
COPY ONLY basetable TO stdout ?
COPY ONLY childtable TO stdout ?
--
Sincerely,
Andrew Lazarus mailto:[EMAIL PROTECTED]BEGIN:VCARD
VERSION:2.1
N:Lazarus;Andrew;;;Ph.D.
FN:Andrew La
Is there some clear reason why I can't using EXECUTE of a PREPAREd query
as I can a SELECT statement in CREATE TABLE AS, INSERT, FROM clause,
sub-selects, etc.? If not, wouldn't this be a very useful change? (Or is
there some special syntax to do this that I can't find?)
Andrew
