Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 20CBF9FBD62
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 28 Feb 2007 14:29:48 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024)
	with ESMTP id 14953-02 for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 28 Feb 2007 14:29:26 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.248])
	by postgresql.org (Postfix) with ESMTP id ED76F9FBD3B
	for <pgsql-admin@postgresql.org>; Wed, 28 Feb 2007 14:29:43 -0400 (AST)
Received: by an-out-0708.google.com with SMTP id c24so180546ana
	for <pgsql-admin@postgresql.org>; Wed, 28 Feb 2007 10:29:43 -0800 (PST)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=CDi6lsmi+3/cXJoKaYFLygsE2HMvOC/GpAblTqK732892F7HIIRPZS/gnX56j8326IW/jysGfTtH6Ct6svbZD2Fukkk8xtXMhmdFQKW3XaWF3E5bgdAqfrFxlhiyoGaI1cizeR+Mk31PQX5wwCexcBTO6x1zt+O7uLCN+XmvAdo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=PuLSrTyf+Gv1ldXVkyw6cicrUB12KZ/h1bcrNqo8T8GBykQrCn8f+H7UHKhxfCuGzG/Q8bzQzFdL9dH9nvnunOHtg4JG5gHHgiWba69m7flVlVyr3gtg1HYI8r8L6oNbQY7Kw55PxCmV8l3R+F9GXRVjOynu1fTICRP66zA/ScQ=
Received: by 10.100.154.13 with SMTP id b13mr749050ane.1172687383161;
	Wed, 28 Feb 2007 10:29:43 -0800 (PST)
Received: by 10.100.33.13 with HTTP; Wed, 28 Feb 2007 10:29:43 -0800 (PST)
Message-ID: <302670f20702281029u6f502a14h3fa28ab41b1d8b4f@mail.gmail.com>
Date: Wed, 28 Feb 2007 13:29:43 -0500
From: "Gary Chambers" <gwchamb@gmail.com>
To: "Karthikeyan Sundaram" <skarthi98@hotmail.com>
Subject: Re: [SQL] system tables inquiry & db Link inquir
Cc: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org
In-Reply-To: <BAY131-F14526BA01BB66AA5D4DB75B0810@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <BAY131-F28E2CC1D1B622B218CD5C3B09D0@phx.gbl>
	<BAY131-F14526BA01BB66AA5D4DB75B0810@phx.gbl>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200702/349
X-Sequence-Number: 24814

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

psql -E -U <user> <db>
\ds

Capture the query that psql sends to the server.

Can't help with the dblink -- sorry.

-- Gary Chambers

// Nothing fancy and nothing Microsoft!