Re: [SQL] Export to XML

2005-11-19 Thread Nikolay Samokhvalov 
You can try to use this patch:
http://archives.postgresql.org/pgsql-patches/2005-09/msg00138.php

This is implementation of basic functions of SQL/XML (14th part of
SQL:2003, http://www.sqlx.org/)

I've successfully applied it to 8.1 version - no troubles.

On 11/11/05, Warren Murray <[EMAIL PROTECTED]> wrote:
> What is the process to export a PostgreSQL table to XML?  How is it done?
> Thanks!
>
> Warren L Murray
> Booz Allen Hamilton
> Phone: 404.518.7940
> Email: [EMAIL PROTECTED]
>
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
>


--
Best regards,
Nikolay

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [SQL] DISTINCT ON

2005-11-19 Thread Bruno Wolff III 
On Sat, Nov 19, 2005 at 17:06:27 +1300,
  Jeremy Palmer <[EMAIL PROTECTED]> wrote:
> 
> Interesting enough, on my server the "distinct on" clause that I originally
> ran takes 10% of execution time that the query you provided does.

If DISTINCT ON wasn't useful, I doubt it would have been added.

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[SQL] Is it possible to redirect an update/insert/delete to a different table?

2005-11-19 Thread Andy Ballingall 








Hello,

 

Is there a way that I can specify that a request to change
to a particular table is redirected instead to a different table?

 

I’ve looked through rules, and as far as I can make
out, they are only useful for explicit actions. I’m looking for something
that behaves as though it simply substitutes the table name for a different
table name before executing the command, no matter what the command looks like.

 

Thanks

Andy Ballingall

[SQL] Create Public Schema

2005-11-19 Thread rsosnowski 
Hello all,

I'm trying to create a schema that contains the default tables, functions, etc. of the public schema.  Using pgAdmin, when I create a schema, it is blank - has no associated aggregates, tables, etc.  How would I create additional schems within a database that mirror the public schema.

ThanksRob