aravind chandu wrote:
Hi,
I have some data
in XML format and i need to upload in postgresql database using stored
procedure. Can someone tell
me the step by step procedure of the same as i will be doing it for the
first time.
Thank You,
Avin.
I have offered a pyt
Iv Ray wrote:
Hi Ray,
I have something that does this. I am currently awaiting project
approval on pgfoundry.
It does tables, views, and stored procedures. I have tested it on
450,000 lines of mssql code
including 400 tables and 3700 stored procedures, although it is a
work in progress.
I a
Iv Ray wrote:
Hello,
what is the current status of the MSSQL to PostgreSQL tools/tips?
Google returns results as old as 2001...
The MSSQL database in question has only tables, no stored procedures,
etc.
Thanks,
Iv
Hi Ray,
I have something that does this. I am currently awaiting project
aravind chandu wrote:
Hi folks,
I need to load xml data in to database can you tell me they way how do
I import xml data into postgresql database.
lets dat this is the xml file
Harry Potter
J K. Rowling
2005
29
Tom Lane wrote:
Gwyneth Morrison <[EMAIL PROTECTED]> writes:
What I am actually trying to get past is:
DELETE FROM data_table1
using data_table2 INNER JOIN
data_table1 ON data_table1.fkey =
data_table
Scott Marlowe wrote:
Take a look here, in the notes section:
http://www.postgresql.org/docs/8.3/interactive/sql-delete.html
on the using keyword.
Thank you for your reply Scott,
I guess this is where the confusion started for me.
It says here in your reference that the using clause is n
--- On Wed, 7/2/08, Gwyneth Morrison <[EMAIL PROTECTED]> wrote:
> From: Gwyneth Morrison <[EMAIL PROTECTED]>
> Subject: [GENERAL] Delete from Join
> To: pgsql-general@postgresql.org
> Date: Wednesday, July 2, 2008, 3:15 PM
> Hello,
>
> Is it possible
Hello,
Is it possible to use a join keyword in a delete?
For example:
DELETE FROM data_table1
using data_table2 INNER JOIN
data_table1 ON data_table1.fkey = data_table2.pkey;
It is not directly mentioned in the delete syntax but the delete refers
to
