pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mario Soto Cordones <msotocl@gmail.com>
To: pgsql-admin@postgresql.org
Subject: catalog of postgres
Date: Wed, 27 Apr 2005 14:02:09 -0400
Message-ID: <e9b17cde050427110228170cf3@mail.gmail.com> (raw)

Hi guys
 
i have a following query:

SELECT nspname as schema, relname as objeto
FROM
  pg_class bc,
  pg_attribute ta,
  pg_namespace ns,
  pg_type ty
WHERE
  ta.attrelid = bc.oid
  and ta.attnum > 0
  and not ta.attisdropped
  and nspname <> 'information_schema' and nspname not like 'pg_%'
  and relam = 0
  and bc.relnamespace = ns.oid
  and bc.relname not like 'pg_%'
  and ta.atttypid = ty.oid
  group by nspname, relname
  order by nspname, relname asc


with this query I obtain the schema name and the objects of this it , but
 like I can know that they are, that is to say if they are tables,
views, functions, sequences, etc ????????

thank  for all

-- 
cordialmente,

Ing. Mario Soto Cordones



view thread (8+ messages)  latest in thread

Message-ID: <e9b17cde050427110228170cf3@mail.gmail.com>
Permalink:  ../e9b17cde050427110228170cf3@mail.gmail.com/
Also on:    postgresql.org/message-id/e9b17cde050427110228170cf3@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: msotocl@gmail.com
  Subject: Re: catalog of postgres
  In-Reply-To: <e9b17cde050427110228170cf3@mail.gmail.com>
  References: <e9b17cde050427110228170cf3@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox