Gauthier, Dave, 06.05.2009 17:40:
Maybe...<ALL> <EMPLOYEES> <EMP EMP_NAME="JOE" JOB="CARPENTER" /> EMP EMP_NAME="FRANK" JOB="PLUMBER"/> EMP EMP_NAME="SUE" JOB="CARPENTER"/> </EMPLOYEES> <JOBS> <JOB JOB_NAME="CARPENTER" SALARY=25.50 /> <JOB JOB_NAME="PLUMBER" SALARY=28.75 /> </JOBS> </ALL> ...equals... create table employees (emp_name varchar[64], job varchar[64]); create table jobs (job_name varchar[64], salary float); insert into employees (emp_name,job) values ('JOE','CARPENTER'); insert into employees (emp_name,job) values ('FRANK','PLUMBER'); insert into employees (emp_name,job) values ('SUE','CARPENTER'); insert into jobs (job_name,salary) values ("CARPENTER",25.50); insert into jobs (job_name,salary) values ("PLUMBER",28.75);
You could use XSLT to tranform the XML into the approriate SQL Statements. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
