we make a dump before ... and with a product pgmanager (ems tech) we do not show any foreign keys.<br /><br /> But I
thinkall of triggers of referenced table are not deleted.<br /><br /> We recreate the schemas ... and now it's
running.<br/><br /> How is it possible to identify Triggers with no referenced tables ?<br /><br /><br /><br /><br />
StephanSzabo a écrit:<br /><blockquote cite="mid20030811063822.W72304-100000@megazone.bigpanda.com" type="cite"><pre
wrap="">OnMon, 11 Aug 2003, BenLaKnet wrote:
</pre><blockquote type="cite"><pre wrap="">How could I do a pg_dump -s ??
on local server ?? </pre></blockquote><pre wrap="">
Yes. I figured you wouldn't want to send your backups with data (I assume
you have pg_dump generated backups ;) ).
You can use pg_dump locally or remotely (using -h and -p options).
Locally, log in as the postgres user and run pg_dump -s <databasename>,
remotely do
pg_dump -s -h <databasehost> -p <databaseport> <databasename>
I believe.
</pre></blockquote>