"C. Bensend" <[EMAIL PROTECTED]> writes: > I have two tables in the same database, whose structure I want to be > identical. Call them 'bob' and 'test_bob' for example.
> If I make a change to the schema of 'bob', I want that exact change to > happen to 'test_bob'. Possibly you could get the effect you want by making one a child of the other. Read up on inheritance. There are some side-effects you'd probably *not* want, so this isn't a perfect solution, but I can't think of anything else. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html