Re: [SQL] schema propagation

2007-06-06 Thread Markus Schiltknecht
Hi, chester c young wrote: has anyone done any work on comparing schemas? There are two different projects called 'pgdiff', you'll find them with google. I'm trying to automatically propagate changes in a master schema to child schemas. All schema changes will originate at master. Curren

Re: [SQL] Inserting data in composite types!

2006-11-13 Thread Markus Schiltknecht
Hi, Rodrigo Sakai wrote: How can I insert a single row in this table??? INSERT INTO employee (emp_salary) VALUES ((1000.00, '(2006/10/10, 2006/12/10)')); BTW: are you sure you don't want to use foreign keys instead? Something like: CREATE TABLE salaries ( id SERIAL PRIMARY KEY, sala