File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Create table backup ............. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Create table backup ............." Watch "Create table backup ............." New topic
Author

Create table backup .............

Tushar Londhe
Greenhorn

Joined: Jul 08, 2008
Posts: 3
Hi Guys,

I want to take back up of a table for ex: table1
I am using PostgreSQL as my dbase.
Wht I am doing is

I am using pg_dump.exe utility to take backup
and I am taking back up into some files ex: filetable1.backup

I am using select * into temp_tbl from table1
Now after this I am executing pg_dump.exe and taking back up into files
after that I am dropping the temp_tbl.

Now because that temp_tbl is deleted I am not able to take back up
However I am taking care that I am dropping the table after I have taken backup.

But still I am not able to create backup ...........Why ???
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Create table backup .............
 
Similar Threads
How to put Row level lock in java while inserting a row in MSSQL table
DELETE using subquery
Problem with file creating....
Backing up database through java
copying arrays from one arraylist to another arraylist