Skip site navigation (1) Skip section navigation (2)

Re: how to search for relation by name?

From: DM <dm(dot)aeqa(at)gmail(dot)com>
To: zach cruise <zachc1980(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to search for relation by name?
Date: 2009-04-22 22:14:29
Message-ID: eae6a62a0904221514m10513b07jf5e9b7047447e2a7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Here is the sql

SELECT c.oid,
  n.nspname,
  c.relname
FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relname LIKE ('%dt%')
  AND pg_catalog.pg_table_is_visible(c.oid)

replace dt with your sequence name

pg_catalog has the information.

Thanks
Deepak


On Wed, Apr 22, 2009 at 2:36 PM, zach cruise <zachc1980(at)gmail(dot)com> wrote:

> when i try to copy database (into another database), i get "relation
> does not exist" errors for 'super objects' like sequences. (that is
> fine since i am using pg_dump, not pg_dumpall) but there is one
> relation i can't find to recreate in the new database.
>
> how can i search database for relation by name (some catalog table)?
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

pgsql-general by date

Next:From: Erik JonesDate: 2009-04-22 22:14:57
Subject: Re: Yet another "drop table vs delete" question
Previous:From: Seref ArikanDate: 2009-04-22 21:48:16
Subject: Re: Help request to improve function performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group