[SQL] Rownum/ row Id

2001-01-30 Thread Padmajha Raghunathan

Hi,

Is there a provision to delete the duplicate records using row num/
row id as available in Oracle???
Thanx in advance

padmajha





[SQL] usage of lo_import

2001-02-01 Thread Padmajha Raghunathan

Hi all,

Thru psql , when i try to insert into the table with the a large
object as insert into some_table values('pp','lo_import('easi.gif'));
it gives an error message as
ERROR:  You must have Postgres superuser privilege to use
server-side lo_import().
Anyone can use the client-side lo_import() provided by libpq.
how do i insert if i am not logging on as postgres user. ?? and how do i
use lo_import over the network???

Thanx in advance

padmajha