X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ADDE6D86A6 for ; Tue, 13 Sep 2005 02:45:43 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53580-09 for ; Tue, 13 Sep 2005 05:45:39 +0000 (GMT) Received: from hotmail.com (bay22-f18.bay22.hotmail.com [64.4.16.68]) by svr1.postgresql.org (Postfix) with ESMTP id CF887D83BC for ; Tue, 13 Sep 2005 02:45:34 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 12 Sep 2005 22:45:33 -0700 Message-ID: Received: from 63.215.198.182 by by22fd.bay22.hotmail.msn.com with HTTP; Tue, 13 Sep 2005 05:45:32 GMT X-Originating-IP: [164.164.12.25] X-Originating-Email: [ashu_shri@hotmail.com] X-Sender: ashu_shri@hotmail.com From: "ashish srivastava" To: pgsql-admin@postgresql.org Subject: some samll questions on postgres Date: Tue, 13 Sep 2005 11:15:32 +0530 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 13 Sep 2005 05:45:33.0153 (UTC) FILETIME=[5B64D510:01C5B826] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.582 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0, RCVD_IN_BL_SPAMCOP_NET=1.832] X-Spam-Level: *** X-Archive-Number: 200509/122 X-Sequence-Number: 18859 hi, I am new to this database can any body help me out by answering some small questions.I am coming from SQLserver2k. I have installed postgres on windows2000 server.I am able to get pgAdminIII console. I have created some databases on postgres using pgAdminIII.But i want to know certain facts:- 1.Where are the datafiles and log files created? what is the concept of pg_default and pg_global(tablespaces). 2.Where we write the stored procedure in postgres? and most importantly 3.How to generate sql scripts of the databases? regards, ashish _________________________________________________________________ Stock Market difficult? http://www.sharekhan.com/campaign/OpenNewAccount.asp?ProdID=23&SrcID=59 Not anymore. Join Sharekhan’s FirstStep