Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3

we make a dump before ... and with a product pgmanager (ems tech) we do
not show any foreign keys.

But I think all of triggers of referenced table are not deleted.

We recreate the schemas ... and now it's running.

How is it possible to identify Triggers with no referenced tables ?

Stephan Szabo a écrit:

>On Mon, 11 Aug 2003, BenLaKnet wrote:
>
>
>
>>How could I do a pg_dump -s ??
>>
>>on local server ??
>>
>>
>
>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.
>
>
>