On Thu, Jan 24, 2008 at 08:06:19AM +1100, Richard wrote:
> Then return to the transformer sql window. The connect string for postgres is
>
> jdbc:postgresql://localhost:5432/hl7testing
That would eventually be "gnumed_vX" where X is the current
schema version.
> and the sql which you can either construct and verify in postgres looks
> something like this:
>
> INSERT INTO haps_patients (firstname,surname) values (
> ${patientIdentification_patientName_familyName},
> ${patientIdentification_patientName_givenName}
> );
In GNUmed would this be:
insert into dem.names (firstnames, lastnames) values (
${patientIdentification_patientName_familyName},
${patientIdentification_patientName_givenName}
);
but it still lacks the value for the foreign key to the
identity table.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
_______________________________________________
Gnumed-devel mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnumed-devel
