how to search for relation by name?

From: zach cruise <zachc1980(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to search for relation by name?
Date: 2009-04-22 21:36:25
Message-ID: bcdac0e80904221436n37f82da0raabc65d6a03c7d1d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seref Arikan 2009-04-22 21:48:16 Re: Help request to improve function performance
Previous Message Hiroshi Inoue 2009-04-22 21:35:28 Re: trouble with to_char('L')