Pop-Up Thingie
Sidebar
>>> Magnum BBS <<<
Home
Forum
Files
Dark
Log in
Username
Password
Sidebar
Forum
Usenet
COMP.DATABASES.POSTGRESQL
pg_dump - exclude tables doesn't work with shell variables
From
Magnus Warker
@21:1/5 to
All
on Thu Apr 14 04:02:58 2016
Hello,
when I call pg_dump directly like this, it works fine:
pg_dump -Uwww -w -T'mig_*' mydb > test.sql
But when I build the commandline within a script with variables, the
table exclusion doesn't work:
#!/bin/sh
OPT="-Uwww -w -T'mig_*'"
f=test.sql
pg_dump $OPT mydb > $f
The dump is created, but it still contains the tables beginnig with "mig_".
What's wrong?
Thanks
Magnus
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
Who's Online
Recent Visitors
Bob Worm
Tue May 7 21:37:57 2024
from
Wales, Uk
via
Telnet
Keyop
Tue May 7 20:20:13 2024
from
Huddersfield, West Yorkshire
via
SSH
Cronus
Wed May 8 19:22:39 2024
from
Provo, Ut
via
SSH
Michal Wronka
Wed May 8 18:58:52 2024
from
Wroclaw, Poland
via
SSH
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
300
Nodes:
16 (
3
/
13
)
Uptime:
72:24:29
Calls:
6,714
Calls today:
2
Files:
12,246
Messages:
5,357,081