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 reply aft 6 hrs , i am abt to crash now).
hope someone else helps u in meantime.
regds
On 3/30/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
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 I restore from one database
with a name to other with another name ?
Regards
Ezequias
Em Thu, 29 Mar 2007 23:46:31 +0530
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> escreveu:
>psql> TRUNCATE TABLE <tablename>;
>
>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
>> 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)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
--
Ezequias Rodrigues da Rocha
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
