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
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 |
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? |