Dump/restore casts

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Dump/restore casts
Date: 2011-05-12 01:52:10
Message-ID: BANLkTi=zbWZkJf8HZEGHnF-pVkKHyBmv+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

If I'm understanding things, pg_dump will not dump casts b/c they are system
objects and belong to neither schema nor database. OK- kind of frustrating-
but OK. Is there, then, any way to easily dump all casts on a server so that
they can easily be copied and recreated in a restoration process?

Thanks.

--
Wells Oliver
wellsoliver(at)gmail(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message anantha.echambadi 2011-05-12 10:26:20 Postgres Incremental Bakcup
Previous Message Brian Fehrle 2011-05-11 22:54:09 Permission Denied for 'pg_stat_tmp/pgstat.tmp' on Windows server 2003 - postgresql 8.4.6