[SQL] Perform a Select on an Oracle Database from PG

[val]

How do I do a cross-database connection?

I have data in a table in Oracle that I need to copy into a 
Postgres table.  It has been suggested to me that I attempt to 
perform a cross-database select instead of exporting the info 
from Oracle into a CSV file and then importing the CSV data into 
Postres. 

Can someone please advise me on how to do this or point me to 
some documentation?

Thank you!

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[SQL] Delete 1 Record of 2 Duplicate Records

[val]

How do I delete only 1 of the duplicate records?


 column_name | column_id
-+--
 test1 | 5
 test1 | 5


I've tried this:

tmp_test=# delete from test where column_id = 5 limit 1;
ERROR:  parser: parse error at or near "limit"

I'm using version 7.2.1

Thank you.

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

http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] which will be faster? w/ or w/o indices

[val]

I understand that if you are importing data into the database 
that this will go faster if there are no indices against the 
target table.

If I want to run this statement:
INSERT INTO table_a SELECT * from table_b WHERE value_1 BETWEEN 
X AND Y;
is it best to do that with or without indices?

AND, if I want to run this statement:
DELETE FROM table_B WHERE value_1 BETWEEN X AND Y;
is it best to do that with or without indices?


We are using v 7.2.1 on a Sun E4500.

TIA,
val



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[SQL] Copy from a SELECT

[val]

I know that the COPY command requires that you work with plain 
tables.

Is there any other way at all of export only part of a table

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org