Re: [Qgis-user] xml metadata in PostGIS table

2016-09-14 Thread Richard McDonnell
Peter, Yes this is almost what I am looking for, 80% there... you appear to be copying and pasting the whole xml, as opposed to reading a file directly to postgres, which is what I need. What I relay need to do is create a batch file for windows, which I can drop into the folder with the

Re: [Qgis-user] xml metadata in PostGIS table

2016-09-13 Thread Schweitzer, Peter
Richard, In PostgreSQL, I store some whole documents as XML, using create table something ( rec_id integer, record xml ); and then insert like this: insert into something (rec_id,record) values ( 1,XMLPARSE (DOCUMENT '<...')); By defining the field "record" as xml, I can use XML