ckly grow beyond
issuing any contentious values.
--->>>>>>>>>>>>>>>>>>>>>
#!/bin/bash
#
# script to include in crontab for 0 1 * * * root /postgresback
# for backup and vacuum of the following two databases
#
# written by Mark C
Hi Armel,
Why not do a structure only dump to plain text and see if you can use
that as your start .sql ext file for 'psql -e .. etc'. Eliminates the
necessity to have an active client side data dictionary. BTW, your english
is fine.
Regards
markcarew@
magicwanddept.com.au
---
situation at restore time.
The dumped file is thus copied back at restore time not inserted.
Regards Mark Carew
Brisbane Australia.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe
ccisa HCCISA.SQL
It would appear on further examinaition that these commands came from
Practical PostgreSQL page 353 onwards.
I remember testing both commands and having success with both backup and
restore.
Good Luck
Mark Carew
Brisbane Australia
"Justin Georgeson&qu
book" SAMS chapter 5 discusses
FOR loops.
Regards Mark Carew
---(end of broadcast)---
TIP 3: 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
foreign key
declarations. I use the views to mimic conditional indices. Each view
has a companion
index generated if one suitable is not already in existance.
HTH
Mark Carew
Brisbane Australia
07 35117911
/* client side */
IF ascan(aTokens,"AUTOINC&
