>I dont think i clearly understand your requirement.
>
>Are you wanting to restore the "PLAIN" backup of a database
>with a different database name ?
>
Yes
Are you getting any particular error?
what platform are you in ?
>what do you mean "deleting information of current database ..."
>
Clear
I dont think i clearly understand your requirement.
Are you wanting to restore the "PLAIN" backup of a database
with a different database name ?
what do you mean "deleting information of current database ..."
I have not used pgAdmin as i prefer cmd line mostly.
eager to help, (expect my next
Thank you all for a so fast reply.
I did a backup PLAIN with pgAdmin and I had to delete the information of the
current database (the database I used to make the backup).
I think that's why pgAdmin does not work with plain backups on Restore.
What does occurs with the information schema when
psql> TRUNCATE TABLE ;
if you have too many tables , generate the above commands
by using a query on tables information schema table.
hope it helps.
On 3/29/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi list,
I have many tables with many constraints and I would like to empty all my
table
Hi list,
I have many tables with many constraints and I would like to empty all my
tables.
There is any simple way to do it ?
I have pgAdmin here but not psql.
Any help would be glad.
Regards
Ezequias
--
Ezequias Rodrigues da Rocha
---(end of broadcast)---
