John Gray wrote:
> On Sat, 2006-06-10 at 14:06 -0400, Tom Lane wrote:
> > John Gray <[EMAIL PROTECTED]> writes:
> > > This is the reason why xpath_table allows you to specify an
> > > identifying field (usually a primary key but doesn't have to be)- the
> > > solution to your question is to join a
On Sat, 2006-06-10 at 14:06 -0400, Tom Lane wrote:
> John Gray <[EMAIL PROTECTED]> writes:
> > This is the reason why xpath_table allows you to specify an
> > identifying field (usually a primary key but doesn't have to be)- the
> > solution to your question is to join an xpath_table that just fet
John Gray <[EMAIL PROTECTED]> writes:
> This is the reason why xpath_table allows you to specify an
> identifying field (usually a primary key but doesn't have to be)- the
> solution to your question is to join an xpath_table that just fetches the
> document number against the primary key, e.g.:
Hi,
On Fri, 09 Jun 2006 08:43:51 +0200, Philippe Lang wrote:
> I'm playing with the contrib/pgxml library under PG 8.1.4, and I'm not sure
> if what I found with pgxml is a feature of a bug:
>
[snip]
> I get:
>
>
> iddoc_num line_numval1val2val3
> 1
Hi,
I'm playing with the contrib/pgxml library under PG 8.1.4, and I'm not sure if
what I found with pgxml is a feature of a bug:
I've got the following table:
CREATE TABLE test
(
id int4 NOT NULL,
xml varchar(200),
CONSTRAINT pk PRIMARY KEY (id)
)
WITHOUT OIDS;
INS
On Tue, 2006-01-24 at 21:34, Tom Lane wrote:
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> > I’ am looking for pgxml module for postgres 7.2.1, someone can help me
> > to find it?
>
> *Please* tell me you are not still using PG 7.2.1.
>
> There are seven subsequent releases in the 7.2 seri
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> Iâ am looking for pgxml module for postgres 7.2.1, someone can help me
> to find it?
*Please* tell me you are not still using PG 7.2.1.
There are seven subsequent releases in the 7.2 series, each containing
fixes for very serious bugs --- see
h
I’ am looking for pgxml module for postgres 7.2.1, someone can help me
to find it?
Thanks
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hi,
I'd like to announce the release of pgxml 1.0, a tool which outputs
PostgreSQL queries in XML format.
Here's a small example:
Run
pgxml -d books -c "select * from books" \
-t library,book -s books.css -o books.xml
The output might look like this