Mail about duplicate rows

From: Vikrant Rathore <vikrant(at)chemquick(dot)com>
To: pgsql-sql(at)hub(dot)org
Subject: Mail about duplicate rows
Date: 1999-06-07 02:33:42
Message-ID: 375B2F86.B124B270@chemquick.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

I am trying to append a table radius from another table radiustemp, both
having the same structure, but want to append only those tuples from
radiustemp which are not there in radius. The size of the table can be
up to 165 MB.
So anyone can suggest me a better way of doing this.

The structure if table is like this .

Table = radius
+----------------------------------+----------------------------------+-------+

| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+

| uname | char()
| 256 |
| logdate | date
| 4 |
| logtime | time
| 8 |
| duration | int4
| 4 |
| status | char()
| 20 |
| nasadd | char()
| 20 |
| port | int4
| 4 |
| bytesin | int4
| 4 |
| bytesout | int4
| 4 |
| packin | int4
| 4 |
| packout | int4
| 4 |
| misc | int4
| 4 |
+----------------------------------+----------------------------------+-------+

Thank's in advance for your help.

Thanks & regards,
Vicky

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Harvey 1999-06-07 02:53:53 ANNOUNCE: unixODBC Beta 1.0.5
Previous Message Antonello De Santis 1999-06-06 18:34:29 Postgresql 6.4.2-4

Browse pgsql-sql by date

  From Date Subject
Next Message Fomichev Michael 1999-06-07 05:11:35 Re: [SQL] Mail about duplicate rows
Previous Message stevew 1999-06-06 18:44:00 function returning arrays?