A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Create table backup .............
Joined: Jul 08, 2008
Jul 08, 2008 01:41:00
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 ???
I agree. Here's the link:
subject: Create table backup .............
Problem with file creating....
DELETE using subquery
How to put Row level lock in java while inserting a row in MSSQL table
copying arrays from one arraylist to another arraylist
Backing up database through java
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013