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 6: explain analyze is your friend
