Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A39039FB921 for ; Mon, 19 Mar 2007 23:20:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 27404-04 for ; Mon, 19 Mar 2007 23:20:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id 4A7439FB8D9 for ; Mon, 19 Mar 2007 23:20:02 -0300 (ADT) Received: (qmail 2993 invoked from network); 20 Mar 2007 02:20:01 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;be12e78d7d4e19f331c06e068d88b0be; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 20 Mar 2007 02:20:01 -0000 Received: (qmail 16888 invoked by uid 1166); 20 Mar 2007 13:20:00 +1100 Received: from 172.20.1.142 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.1.142):. Processed in 0.309148 secs); 20 Mar 2007 02:20:00 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.1.142):. Processed in 0.309148 secs Process 16882) Received: from unknown (HELO ?172.20.1.142?) (phillip.smith@weatherbeeta.com.au@172.20.1.142) by mail.weatherbeeta.com.au with SMTP; 20 Mar 2007 13:19:58 +1100 Subject: Re: how to create field auto increas value From: Phillip Smith To: "gunartha.nyoman" Cc: pgsql-admin@postgresql.org In-Reply-To: <001901c76a9a$5f6ff8b0$fd0010b2@idas> References: <001901c76a9a$5f6ff8b0$fd0010b2@idas> Content-Type: multipart/signed; micalg=sha1; protocol="application/x-pkcs7-signature"; boundary="=-kM9OOqRVu1hNnl1kXYUM" Organization: Weatherbeeta P/L Date: Tue, 20 Mar 2007 13:19:51 +1100 Message-Id: <1174357191.10466.9.camel@it-laptop> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1174357201.194-2981-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.05/0.10 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/127 X-Sequence-Number: 24951 --=-kM9OOqRVu1hNnl1kXYUM Content-Type: multipart/alternative; boundary="=-ZJvfePDPTf7MJfe42w3r" --=-ZJvfePDPTf7MJfe42w3r Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Look at the "serial" data type in the documentation. ~p On Tue, 2007-03-20 at 09:49 +0700, gunartha.nyoman wrote: > Dear All, > =20 > I am trying to create table which have one field auto increas value > like autonumber in ms access. > My question is how to create this auto increas field. > =20 > Thank a lot for your attention >=20 > Regards, > Nyoman/Bali >=20 > =20 > =20 --=-ZJvfePDPTf7MJfe42w3r Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Look at the "serial" data type in the documentation.
~p

On Tue, 2007-03-20 at 09:49 +0700, gunartha.nyoman wrote:
Dear All,
 
I am trying to create table wh= ich have one field auto increas value like autonumber in ms access.<= /FONT>
My question is how to create t= his auto increas field.
 
Thank a lot for your attention=

Regards,
Nyoman/Bali

 


--=-ZJvfePDPTf7MJfe42w3r-- --=-kM9OOqRVu1hNnl1kXYUM Content-Type: application/x-pkcs7-signature; name=smime.p7s Content-Disposition: attachment; filename=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGQzCCAvww ggJloAMCAQICECgGLzg4fvuywaSUPjOvpbowDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MDIwNzA1MTc0M1oXDTA4MDIwNzA1MTc0 M1owUzEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEwMC4GCSqGSIb3DQEJARYhcGhp bGxpcC5zbWl0aEB3ZWF0aGVyYmVldGEuY29tLmF1MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB CgKCAQEA0g7kg7BnVTuTt66o+M4w+YJ2sAt6abjbBLngvHoEx79/wrvCTMK0SlVdpR1P+qxM+Qpd Hnzi2iMvBbHJjJIgFndQtpF31RIlj1+/MSB7B4yzRwDIgiljPwVYUfJ8s2/M2++/wcCOi74OpSNF Um0HwZ8bPUohFpHeo3rjGjH4Ma3jOs2TH7jVI808T8bU24JleARbMpm8rCTcK2j0PTxYGCjvN15J FAOTr93yOJS0nMZbC7XCABPCxxpfWUi4x39Gx7dOKc/SskT1P+HHpDS41hSJ6C1fgnHgrjiUWF61 wkG+5pPRTsesxYDoIDsCOthz1VY2u7ncfg6itOLD41HrTQIDAQABoz4wPDAsBgNVHREEJTAjgSFw aGlsbGlwLnNtaXRoQHdlYXRoZXJiZWV0YS5jb20uYXUwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0B AQUFAAOBgQACDFff/JMrNXly4WjbURYqld66NXpVnF6EMR/32JlA5eh/hiA49EKKbrkUgFETxfPD QasscsNEkBjcXoibq+Fk6JZNG3mA5Rct2aks3gP9fupVtcBJETXpLqlJ3CZsiX+fnFw/HgZtKRNV vam0kvXdHBY+WfYMQTTugskfCHVaqjCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdEx CzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEa MBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2Vydmlj ZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqG SIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0x MzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAo UHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCB nzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9Vvy Gna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0D viv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNV HRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9U aGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEa MBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNm rGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQ lGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11f ZU8xggH8MIIB+AIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGlu ZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBD QQIQKAYvODh++7LBpJQ+M6+lujAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEH ATAcBgkqhkiG9w0BCQUxDxcNMDcwMzIwMDIxOTUxWjAjBgkqhkiG9w0BCQQxFgQUlpWtOCtF/x9W lwJ7Vvt+7zffXhUwDQYJKoZIhvcNAQEBBQAEggEAZuuIHMB6SqdQfvzx0V8oI9SicNb2oD+JTotO Cqti/NgQ6+EEflp1Y5Ytnofx0tZIij3u5b3caPxcnngoCHJBOyN0lvD5StmTJAxLUml6BH0JD5hh ArQNXMGc142ZrQf5+NYDgMawXskZGC07T6tvcvxKg6250TRpfOYErpc9oOiq14z9e/CxBlEBX2CZ pSiZL29hYA7Fyfy6L5PjoBGLXEcQlqQUTqYEUm8NAXZr0ZpMTzxxI61rIqvrZKMdzmN9rGhDENdG 92xbbstg61XWuc/rtN8mSLeZohCGk7zc3VQ52f4nh+M8GlR4HQL8EGyzUhJhYBLQfD3TaWC2ybjg YgAAAAAAAA== --=-kM9OOqRVu1hNnl1kXYUM--