Skip site navigation (1)
Skip section navigation (2)
Hi list,
I would like to overwrite a table with problem with his original. But there are some points.
I can't just delete and restore it becouse it has a foreign key and when I try to delete it ask for drop cascade.
As I know the drop cascade delete in both tables the rows related. Is it correct ?
Regards...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
Peripheral Links
Header And Logo
|
Site Navigation
How to overwrite a table [only data]?
- From: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
- To: "pgAdmin Support" <pgadmin-support(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
- Subject: How to overwrite a table [only data]?
- Date: Wed, 4 Oct 2006 08:40:15 -0300
- Message-id: <55c095e90610040440v431e15a3m34fa72ef19c239e8(at)mail(dot)gmail(dot)com>
Hi list,
I would like to overwrite a table with problem with his original. But there are some points.
I can't just delete and restore it becouse it has a foreign key and when I try to delete it ask for drop cascade.
As I know the drop cascade delete in both tables the rows related. Is it correct ?
Regards...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
- Follow-Ups:
- Re: How to overwrite a table [only data]?
- From: Markus Schaber
- Re: How to overwrite a table [only data]?
- From: Aaron Bono
- Re: How to overwrite a table [only data]?
- Prev by Date: Re: i have table
- Next by Date: Re: Assigning a timestamp without timezone to a timestamp
- Previous by thread: formatting intervals with to_char
- Next by thread: Re: How to overwrite a table [only data]?
- Indexes: