[SQL] Copy from a SELECT

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

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

, 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] Delete 1 Record of 2 Duplicate Records

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

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

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 Pos