Re: [SQL] Xml Schemas

On Saturday 06 June 2009 22:53:19 Isaac Dover wrote: > Hello, I am attempting to build an xml representation of any database, but > I'm having trouble doing so. I was interested in using the existing xml > functions, such as "schema_to_xmlschema", but the results are strange and > unusable. The res

[SQL] Xml Schemas

Hello, I am attempting to build an xml representation of any database, but I'm having trouble doing so. I was interested in using the existing xml functions, such as "schema_to_xmlschema", but the results are strange and unusable. The resulting schema doesn't even contain the column names, though i

[SQL] SQL/XML Multi table join question

Hi all, I have the following tables (parent and two children) CREATE SEQUENCE person_seq; CREATE TABLE person( _id integer DEFAULT nextval('person_seq') NOT NULL, _timestamp TIMESTAMP NOT NULL, _lastModified TIMESTAMP NOT NULL, name VARCHAR(255) NOT NULL,

[SQL] XML

Title: XML I need help in getting the xml contribution installed. I have installed the contrib package for Postgres 7.4.5 and would appreciate any guidance as to how I get this working? Theo __ This email, including attac

Re: [SQL] XML data field

[EMAIL PROTECTED] wrote: Does anyone have any experience in retrieving and formatting an XML data from a field using pgSQL? Are there any system stored procs that could reformat the XML elements or just retrieve the elements needed? There are some xml-related functions in the contrib/ directory of

[SQL] XML data field

Does anyone have any experience in retrieving and formatting an XML data from a field using pgSQL? Are there any system stored procs that could reformat the XML elements or just retrieve the elements needed?   Thanks! - Lily Anne

Re: [SQL] XML & Postgres Functions

hi, zerobearing2 wrote: Hi all- I'm migrating to postgres from the MS SQL Server land, as I can see a great potential with postgres, I was wondering if anyone has experimented or started a project with XML inside user defined functions? I've seen the contrib/xml shipped with the distro, as I see

[SQL] XML & Postgres Functions

Hi all- I'm migrating to postgres from the MS SQL Server land, as I can see a great potential with postgres, I was wondering if anyone has experimented or started a project with XML inside user defined functions? I've seen the contrib/xml shipped with the distro, as I see it's usefulness, it's no

Re: [SQL] XML to Postgres conversion

On Thu, Jul 11, 2002 at 09:23:39AM -0500, [EMAIL PROTECTED] wrote: > Look at contrib/xml at > http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml/. I never > used this, but it might be useful. > > George Essig > > > Hello. > > > > I am trying to figure out how to import xml documents i

Re: [SQL] XML to Postgres conversion

Hi, Hey wow the contrib/xml looks most impresive. I'm so stoopid I've being looking around for xml solutions with even knowing about the contrib/xml in my beloved postgreSQL source. Thanks for the tip. Cheers Rudi. > Look at contrib/xml at > http://developer.postgresql.org/cvsweb.cgi/pgsql/co

Re: [SQL] XML to Postgres conversion

Look at contrib/xml at http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml/. I never used this, but it might be useful. George Essig > Hello. > > I am trying to figure out how to import xml documents into a postgres > database. I am running PostgreSql 7.1.3 on Red Hat 7.2 at the momen

[SQL] XML to Postgres conversion

Hello. I am trying to figure out how to import xml documents into a postgres database. I am running PostgreSql 7.1.3 on Red Hat 7.2 at the moment. I have several dynamic xml documents that I want imported into the database on a regular basis. From my research so far, I know that there is middl

[SQL] xml perl & pgsql

Dear Postgresql Users Can any one tell me where I can find some XML to Postgresql routines written in Perl. Thanks in advance for your help and assistance. Regards Philip