Here is the sql
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relname LIKE ('%dt%')
replace dt with your sequence name
pg_catalog has the information.
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:
In response to
pgsql-general by date
|Next:||From: Erik Jones||Date: 2009-04-22 22:14:57|
|Subject: Re: Yet another "drop table vs delete" question|
|Previous:||From: Seref Arikan||Date: 2009-04-22 21:48:16|
|Subject: Re: Help request to improve function performance|