Re: XML -> PG ?

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