X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D6C65D1D461; Tue, 20 Jan 2004 14:31:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 31921-03; Tue, 20 Jan 2004 10:31:21 -0400 (AST) Received: from smtp.ualg.pt (smtp.ualg.pt [193.136.224.8]) by svr1.postgresql.org (Postfix) with ESMTP id 6AF3BD1D28A; Tue, 20 Jan 2004 10:31:15 -0400 (AST) Received: from localhost (smtp.ualg.pt [127.0.0.1]) by smtp.ualg.pt (Postfix) with ESMTP id 35B784BD3E; Tue, 20 Jan 2004 14:31:03 +0000 (WET) Received: from smtp.ualg.pt ([127.0.0.1]) by localhost (smtp.ualg.pt [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 22358-07; Tue, 20 Jan 2004 14:30:59 +0000 (WET) Received: from ualg.pt (corisco.uceh.ualg.pt [10.10.20.126]) by smtp.ualg.pt (Postfix) with ESMTP id 068524BD52; Tue, 20 Jan 2004 14:30:58 +0000 (WET) Message-ID: <400D3BA1.5040504@ualg.pt> Date: Tue, 20 Jan 2004 14:30:57 +0000 From: Luis Sousa User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031107 Debian/1.5-3 X-Accept-Language: en-pt MIME-Version: 1.0 To: Ganesan Kanavathy Cc: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] Database diagram References: <200401200638.i0K6caI4007124@magnusquest.com> In-Reply-To: <200401200638.i0K6caI4007124@magnusquest.com> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms000003070104080900070202" X-Virus-Scanned: by amavisd-new X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/215 X-Sequence-Number: 12078 This is a cryptographically signed message in MIME format. --------------ms000003070104080900070202 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Ganesan Kanavathy wrote: >I have a postgres database with many tables. > >How do I create database diagram? Are there any free tools available to >create database diagram from pgsql database? > >Regards, >Ganesan > > > > >---------------------------(end of broadcast)--------------------------- >TIP 8: explain analyze is your friend > > > > Did you already tried dia? I never used it, but someone told me that imports data definition from PostgreSQL. You can try it. Luis Sousa --------------ms000003070104080900070202 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJ1jCCBOcwggSRoAMCAQICCh8kvbEAAgAAAC4wDQYJKoZIhvcNAQEF BQAwgaExHDAaBgkqhkiG9w0BCQEWDWRyb3NhQHVhbGcucHQxCzAJBgNVBAYT AlBUMRAwDgYDVQQIEwdBbGdhcnZlMQ0wCwYDVQQHEwRGYXJvMSAwHgYDVQQK ExdVbml2ZXJzaWRhZGUgZG8gQWxnYXJ2ZTEgMB4GA1UECxMXU2Vydmljb3Mg ZGUgSW5mb3JtYXRpY2ExDzANBgNVBAMTBlVhbE5ldDAeFw0wMzA2MjcwOTEw MDlaFw0wNDA2MjYwOTEwMDlaMEgxHjAcBgkqhkiG9w0BCQEWD2xsc291c2FA dWFsZy5wdDEmMCQGA1UEAxMdTFVJUyBNSUdVRUwgTElNQSBTT1VTQSAoMTY3 NCkwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC8A5OkecBnTdUd ugVd25juvz37x7jT7zml1+eyrWV+kMcsyT4bObYrsbQAuPIrToIoILfiVG9G NbtSilK2g0OvTiEqtVnMic4juVn/i3C0Lvmn+r+2m94swL3NPXE4iXOSjwwq KLRVo0pA6Ilko+gDO38B+vUjlTji36X9UqiFufos9Rzkv0egyxKlAOE6VmQv dQ2HOpfpgJd21klhql5jHqELYbaH32GoSZfwDYin2qGzkeouXftmSJrwIKO4 8UIq43mgGcXU8Jao+peHeWA48CpV35/cAqMHVkaMRRS3BhjeNRWGgM3PvmW1 rhWGoxqXJIjasTITDuNuh/p3ToaVAgMBAAGjggI5MIICNTAdBgNVHQ4EFgQU Cg/am0sCxNrzOW7TAnBVrEQn/Kkwgd0GA1UdIwSB1TCB0oAUDlemmBHtWUTt GV2FEEod0l87V/qhgaekgaQwgaExHDAaBgkqhkiG9w0BCQEWDWRyb3NhQHVh bGcucHQxCzAJBgNVBAYTAlBUMRAwDgYDVQQIEwdBbGdhcnZlMQ0wCwYDVQQH EwRGYXJvMSAwHgYDVQQKExdVbml2ZXJzaWRhZGUgZG8gQWxnYXJ2ZTEgMB4G A1UECxMXU2Vydmljb3MgZGUgSW5mb3JtYXRpY2ExDzANBgNVBAMTBlVhbE5l dIIQS1dGfnTvEatHwdnJY6a3STA8BgNVHR8ENTAzMDGgL6AthitodHRwOi8v d3d3LnNpLnVhbGcucHQvQ2VydEVucm9sbC9VYWxOZXQuY3JsMFoGCCsGAQUF BwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0cDovL3d3dy5zaS51YWxnLnB0L0Nl cnRFbnJvbGwvcHVjY2luaS51YWxnLnB0X1VhbE5ldCgyKS5jcnQwDAYDVR0T AQH/BAIwADALBgNVHQ8EBAMCBaAwKQYDVR0lBCIwIAYKKwYBBAGCNwoDBAYI KwYBBQUHAwQGCCsGAQUFBwMCMBcGCSsGAQQBgjcUAgQKHggAVQBzAGUAcjA7 BgNVHREENDAyoB8GCisGAQQBgjcUAgOgEQwPbGxzb3VzYUB1YWxnLnB0gQ9s bHNvdXNhQHVhbGcucHQwDQYJKoZIhvcNAQEFBQADQQAD4U2BxW5hvZ2LAmt+ kVCe0qxgH4dXgNEzbbE2v0J/sWkw3LMezecV00U5ZaPXt7dzTB45c8Iy8d0Q xmCPh5gaMIIE5zCCBJGgAwIBAgIKHyS9sQACAAAALjANBgkqhkiG9w0BAQUF ADCBoTEcMBoGCSqGSIb3DQEJARYNZHJvc2FAdWFsZy5wdDELMAkGA1UEBhMC UFQxEDAOBgNVBAgTB0FsZ2FydmUxDTALBgNVBAcTBEZhcm8xIDAeBgNVBAoT F1VuaXZlcnNpZGFkZSBkbyBBbGdhcnZlMSAwHgYDVQQLExdTZXJ2aWNvcyBk ZSBJbmZvcm1hdGljYTEPMA0GA1UEAxMGVWFsTmV0MB4XDTAzMDYyNzA5MTAw OVoXDTA0MDYyNjA5MTAwOVowSDEeMBwGCSqGSIb3DQEJARYPbGxzb3VzYUB1 YWxnLnB0MSYwJAYDVQQDEx1MVUlTIE1JR1VFTCBMSU1BIFNPVVNBICgxNjc0 KTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBALwDk6R5wGdN1R26 BV3bmO6/PfvHuNPvOaXX57KtZX6QxyzJPhs5tiuxtAC48itOgiggt+JUb0Y1 u1KKUraDQ69OISq1WcyJziO5Wf+LcLQu+af6v7ab3izAvc09cTiJc5KPDCoo tFWjSkDoiWSj6AM7fwH69SOVOOLfpf1SqIW5+iz1HOS/R6DLEqUA4TpWZC91 DYc6l+mAl3bWSWGqXmMeoQthtoffYahJl/ANiKfaobOR6i5d+2ZImvAgo7jx QirjeaAZxdTwlqj6l4d5YDjwKlXfn9wCowdWRoxFFLcGGN41FYaAzc++ZbWu FYajGpckiNqxMhMO426H+ndOhpUCAwEAAaOCAjkwggI1MB0GA1UdDgQWBBQK D9qbSwLE2vM5btMCcFWsRCf8qTCB3QYDVR0jBIHVMIHSgBQOV6aYEe1ZRO0Z XYUQSh3SXztX+qGBp6SBpDCBoTEcMBoGCSqGSIb3DQEJARYNZHJvc2FAdWFs Zy5wdDELMAkGA1UEBhMCUFQxEDAOBgNVBAgTB0FsZ2FydmUxDTALBgNVBAcT BEZhcm8xIDAeBgNVBAoTF1VuaXZlcnNpZGFkZSBkbyBBbGdhcnZlMSAwHgYD VQQLExdTZXJ2aWNvcyBkZSBJbmZvcm1hdGljYTEPMA0GA1UEAxMGVWFsTmV0 ghBLV0Z+dO8Rq0fB2cljprdJMDwGA1UdHwQ1MDMwMaAvoC2GK2h0dHA6Ly93 d3cuc2kudWFsZy5wdC9DZXJ0RW5yb2xsL1VhbE5ldC5jcmwwWgYIKwYBBQUH AQEETjBMMEoGCCsGAQUFBzAChj5odHRwOi8vd3d3LnNpLnVhbGcucHQvQ2Vy dEVucm9sbC9wdWNjaW5pLnVhbGcucHRfVWFsTmV0KDIpLmNydDAMBgNVHRMB Af8EAjAAMAsGA1UdDwQEAwIFoDApBgNVHSUEIjAgBgorBgEEAYI3CgMEBggr BgEFBQcDBAYIKwYBBQUHAwIwFwYJKwYBBAGCNxQCBAoeCABVAHMAZQByMDsG A1UdEQQ0MDKgHwYKKwYBBAGCNxQCA6ARDA9sbHNvdXNhQHVhbGcucHSBD2xs c291c2FAdWFsZy5wdDANBgkqhkiG9w0BAQUFAANBAAPhTYHFbmG9nYsCa36R UJ7SrGAfh1eA0TNtsTa/Qn+xaTDcsx7N5xXTRTllo9e3t3NMHjlzwjLx3RDG YI+HmBoxggQXMIIEEwIBATCBsDCBoTEcMBoGCSqGSIb3DQEJARYNZHJvc2FA dWFsZy5wdDELMAkGA1UEBhMCUFQxEDAOBgNVBAgTB0FsZ2FydmUxDTALBgNV BAcTBEZhcm8xIDAeBgNVBAoTF1VuaXZlcnNpZGFkZSBkbyBBbGdhcnZlMSAw HgYDVQQLExdTZXJ2aWNvcyBkZSBJbmZvcm1hdGljYTEPMA0GA1UEAxMGVWFs TmV0AgofJL2xAAIAAAAuMAkGBSsOAwIaBQCgggI7MBgGCSqGSIb3DQEJAzEL BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA0MDEyMDE0MzA1N1owIwYJ KoZIhvcNAQkEMRYEFPZT7JIM7PeWT8C+gPUBrYuC5XjmMFIGCSqGSIb3DQEJ DzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3DQMC AgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMIHBBgkrBgEEAYI3EAQxgbMw gbAwgaExHDAaBgkqhkiG9w0BCQEWDWRyb3NhQHVhbGcucHQxCzAJBgNVBAYT AlBUMRAwDgYDVQQIEwdBbGdhcnZlMQ0wCwYDVQQHEwRGYXJvMSAwHgYDVQQK ExdVbml2ZXJzaWRhZGUgZG8gQWxnYXJ2ZTEgMB4GA1UECxMXU2Vydmljb3Mg ZGUgSW5mb3JtYXRpY2ExDzANBgNVBAMTBlVhbE5ldAIKHyS9sQACAAAALjCB wwYLKoZIhvcNAQkQAgsxgbOggbAwgaExHDAaBgkqhkiG9w0BCQEWDWRyb3Nh QHVhbGcucHQxCzAJBgNVBAYTAlBUMRAwDgYDVQQIEwdBbGdhcnZlMQ0wCwYD VQQHEwRGYXJvMSAwHgYDVQQKExdVbml2ZXJzaWRhZGUgZG8gQWxnYXJ2ZTEg MB4GA1UECxMXU2Vydmljb3MgZGUgSW5mb3JtYXRpY2ExDzANBgNVBAMTBlVh bE5ldAIKHyS9sQACAAAALjANBgkqhkiG9w0BAQEFAASCAQCmFNYU4kIXgG5y ZHas1wzlTRmNrmRPFHNr38hMTMqIZavfSNfnBe3u0ZDZfUgdW+XVGwrME1Y0 3RU5WRqemlhhS2IKnc31uBeLY2Xptm8tV2cMWNSssASeCpOI0EOniB6NVqBf FSfjYSUl1uO3bYv5Oddc5b+pg13nHxX8PwmQ5S9FcbWOZgx1OTxcbj/HWZ1d iZ1rxI3nQC9Gmjzt53LK00L+JkhhmP2KTwiTJ/s40MRqB/S1m2R02AvfWN4O ywstQe9oS3mcZBgzawGaeEG++eDJlso5gNqCjzHWm3cde6eZT77Up0Ss51Hl v/WgFrdpXpSg97YGasxkpiNUnTKOAAAAAAAA --------------ms000003070104080900070202--