Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 034479FBC5A;
	Wed, 28 Feb 2007 14:19:25 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 50754-02; Wed, 28 Feb 2007 14:19:13 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from bay0-omc3-s40.bay0.hotmail.com (bay0-omc3-s40.bay0.hotmail.com
	[65.54.246.240])
	by postgresql.org (Postfix) with ESMTP id 8EE579FBC4B;
	Wed, 28 Feb 2007 14:19:20 -0400 (AST)
Received: from hotmail.com ([65.55.136.94]) by bay0-omc3-s40.bay0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.2668);
	Wed, 28 Feb 2007 10:19:19 -0800
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Wed, 28 Feb 2007 10:19:18 -0800
Message-ID: <BAY131-F14526BA01BB66AA5D4DB75B0810@phx.gbl>
Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP;
	Wed, 28 Feb 2007 18:19:15 GMT
X-Originating-IP: [67.116.31.14]
X-Originating-Email: [skarthi98@hotmail.com]
X-Sender: skarthi98@hotmail.com
In-Reply-To: <BAY131-F28E2CC1D1B622B218CD5C3B09D0@phx.gbl>
From: "Karthikeyan Sundaram" <skarthi98@hotmail.com>
To: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org
Subject: system tables inquiry & db Link inquiry
Date: Wed, 28 Feb 2007 10:19:15 -0800
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
X-OriginalArrivalTime: 28 Feb 2007 18:19:18.0879 (UTC)
	FILETIME=[F633B6F0:01C75B64]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.613 tagged_above=0 required=5 tests=AWL, BAYES_40,
	DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS
X-Spam-Level: *
X-Archive-Number: 200702/348
X-Sequence-Number: 24813

Hi,

    We are using Postgres 8.1.0

  Question No 1:
  =========
   There are lots of system tables that are available in postgres. For 
example pg_tables will have all the information about the tables that are 
present in a given schema.  pg_views will have all the information about the 
views for the given schema.

    I want to find all the sequences.  What is the system tables that have 
the information about all the sequences?

   Question No 2:
   =========

     I have 2 postgres instance located in two different servers.   I want 
to create a DBlink (like in Oracle) between these 2.  What are the steps 
involved to create this.

   Any examples?  Please advise.

Regards
skarthi

_________________________________________________________________
Win a Zune™—make MSN® your homepage for your chance to win! 
http://homepage.msn.com/zune?icid=hmetagline