highgo database中\copy可以导出二进制文件（图片等）

来源：互联网发布：足彩缩水软件编辑：程序博客网时间：2024/06/05 16:32

[highgo@sourcedb ~]$ ll /home/highgo/desk.jpg
-rwxrwxrwx 1 highgo highgo 72902 Jun 21 15:29 /home/highgo/desk.jpg
[highgo@sourcedb ~]$ xxd -p /home/highgo/desk.jpg | tr -d '\n' > /tmp/image.hex
[highgo@sourcedb ~]$ psql
psql (3.1.4)
Type "help" for help.
highgo=# CREATE TABLE hexdump (hex text);
CREATE TABLE
highgo=# COPY hexdump FROM '/tmp/image.hex';
COPY 1
highgo=# CREATE TABLE bindump (binarydump bytea);
CREATE TABLE
highgo=# INSERT INTO bindump (binarydump) (SELECT decode(hex, 'hex') FROM hexdump limit 1);
INSERT 0 1
highgo=# \copy bindump to /tmp/bindump.log;
COPY 1
highgo=# \q

[highgo@sourcedb ~]$ more /tmp/bindump.log
\\xffd8ffe000104a46494600010101006000600000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d3
8323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc200110801d6032
203012200021101031101ffc4001b00000203010101000000000000000000000001020304050607ffc4001a010002030101000000000000000000000000030102040506ffda000c03010002100310000001e7487
dae2a52262b760a664b6f2269bd3b528b26e612917a50b4887e73484649e8730949b558afb853733d24c525c56d546f7311aee2d4a1dd35b79b3ece7cdab9b3db06a725f60e4473ec418a7a48b510d4064b6d619
adb15e91a348b654ec2f4848297c965e053631c9af36d4b6659de45a92d2629b418baead244d0afb51a39e74da5d86170f43849354aae82468cb5f6f8cb612b236ad4ee531457759a73d475f1e3d9cfb5cde8ae3
72adf3b65d6949684a0094006a60241800c006026381318263210c006400c04d84a1b0437045b010c0449022456d98d267d30721c98b6eea4a48988c9843094302248088c0434086021a910c04a4810d02181118
09324435465339a4b50cd0888d5a2248cfa2ee4f4144c28d2a623288b6464cd08ba9053689583295edca10a3224498c5a0094303530120d8277f450de39d3cf319463540c04c7027d9ce87f39e8a5aa8b65aa9b2
250fd42dbe5cf4705b7cfbf45607993b1c9626248bd225bd04b79474690c849396a44a22b192449011240446021a043d516c8bab5a5bce34e77aa2326a86a413eba5bc75d4a0311383968688432488eea5b39a92
ed995d536a932f083456731daa10ee59af23d486af086810c2526024c04984a4c049808644ee85d552a0cbab6fb1f1fec78bd6a2ea6d4ebf3bc6f75e1fabc8437a722181ee79fd1e4f95f4dd0e3efc1a737146fd
070d0dc0bdf782f7b8fa18723864de75e8d61c5f3be8fcf6ee64491a32cbd8791f5fcae9d1763e927670389ee7c47479829c756381224d1ea7cbfacc1d2af9fd3a11afc943b5c6e8f212926a574b9dd243bd0271
e2f6acf35e82bd68f2233a1812927e65ee3c47b7e6743168ab6737a3e738deb7cb76f9150cd7912920d9d4a77f9bea66a77e14df87092f53ca49bbc2d98f6aafecb9fd2e179aef6ef2de83cff00471e21aed7290
d1275b93d7537d6ab63c8eb713ca7bef3daf2f9f4ce8f3d261293010c0d36328843726bf5fe43d370fb12b23234cbc47b7f13d0e626cd78531c1ed791d1e4793f51b32e88b53c12bbbd2f9e4360bddf86f7393a1
cfa35e0c9bf4efe1c94cb381d5e66fe64491af0bf59e57d1f27a94e9c7aabaf6f89f6be3b6f3e109ad7822324bfd4f97f4b8ba4e219f573785ddf3da32d8aabf0f496fcbbb06fedc73dfa79a929ba7ca435d7cae
f662e83d70f6de2bd7bf95568cbab467d5e1fde784dd8738d6fe72180b799f369e8909d2b9b9bdbe7bd790717d16dc7ad4cf67c2e872bcc77f4f1bd073f7e5e02b2beef1d0d48badcaeaa9bebe29727ac703bfc0
6afcd0d75f9426a01340004f4eb1d33263997e83cfd9934fab8f94b28ff0057e4a2df990db5098c3ab9b23c3b7a59f2b98ae7235e54db08fb7f151469f670f1e2747b1e2f26dc9ab5639a6a6249747991ebf2a59
b47527c6757fa8f3045a982927e64a482ef4be55e7d9ea4f2c29dd7f33b3360ebbd34dfcbebdd376533eadbc98eac7d2b79630a6bd2b26bc95ecae5993afcf2d1d8d7e66beaf1bd8791ce7578d11a7e643516dfa
7119375a7396ac1b31ca3224cb91620f474f1e5c8e9fa2e1e386a438b376449a90ea72e6bbfbd3c3ac1bfdcf038b5b2940d6fc226810d128606aba9bf34036d446da6a46894b2684e895b90276b6f5f3936120dc
19b4e7d2a784862936e26aaa19b36de8d196c8b6db305735d738541bc90fc918ceb92061ab2eeeabe5f5189063f3578777333ec9df4456dd71a992b4619f33b7af4e0e964d574279ad9ac79f5dd22b2a998e8af6
857cced71a8ccf1b60f5caa54efe7eab72c295b2dcb055a56547470eba32cad6b6da6b9ae97cdb49d253e82c8e4c7bbc0c1bb6d78612ce869e3cd95d19e92d16b4ba5ccb21499b56ba6a8cc6fc53a96cd50a4652
435ab321a04309e8b525e74d9109b6098e04499298e04db894db2536e2536e262e41343bb9c8d5aede6346ad0c8b1373af3c4f4942dd38e2a44c0acae26b6cb56230888c9126020b68dc367471796f6d2bebbd75
77c6d945922db22a9ca5788ab616ac21a113921aaa9b70a9587bdc2d9d2c9d5e2df157ba185bcf86f83230ad91d6acd0d10d14a55ac0dfb7859d9e97c934abd36d77f409554ddbd6867439e823169144b1ec95f8
5b1762a62a76d54c2ebb40d9910c25001d2635674db04c700c7003609b7129b7129b7164e444a6d9316dc4a1b08b6128644a24044681489935d738cd62a44c4464c446810d48ac83e7f57a39a7b38ddde6dc589b
4ad8dd64bba175d0160ca430f439f5bee2536528e775781ab3f3072eef0bad7e83c8f6f2c752a1921b23118abdb5c571436c66b8aeb2b932d3a68bc55d9e3f71d3ceabd4795efe3cca4b76549a910d020094a481
26024c04984a1a24003a8c69cc9b02dd757a4e674fcf57dcd1577957d2e7f43989b7344db275aeac791d9e557e833684f1dc96cc09b094488989db9e7dbc23abcbbad0c6e74a522775f2db93a1cf3a056fce3a20
78f719f43909326225fe813a7cb55ebb9fceece0dd83573ba16474d30a92b6b95e0bb03dd9bab673355abd4a2e9e472ba165e873ba7c9d6aadf9a8357ef1bb73bb9ecb3294d7a32ae32e4e777d4faf9f1f2af57b
68577233e5cfab3c533f7b87ebb55a98f663d3b71d76641e7bcc7bdf05b70806cc8bafc8f6f83679ccfeb2ecbabc157ec7c9f470d499a1080250c040075d77f8596a98ee9d3e93ce7a1e3f6731081b3779af4be7
3673064b4614db89ee55651c3f43af562d9aa3814e8a7771a2d96aa1913da9d33c3d95876d331cb64b6f2073aa27ada33eec9d3e44b6a2d2ba32a5bc7d90b3a7c38a9298b7d1f9cf418fa52a2714ebe746eab9fb
75d560b8945c655c205b9576bc1787a0b6bbd720d4c2e0f46a7afe6d0f4845f47b6e1f70315b0b739056143c1dd972e4d9b6a5729bd6ab5f3ef9b4e7d59ebcccbeb7ca7abdf7e8c266bd1098064f07ef3c1f439c
266ec2bdb789f69ccdf29d3673fa3a7c6faef23d0c5ce4ce9f350008689000f67c4b238ea98d89bfafc3e9f27afb73e9acd9a3cf77b89ab9f16dbf10db89e95309f1fb9b3663b741caa6fa767290cb511203a538
4f1f65557544732d4f5f2e106acbebeec3bb1f5529146f32a8c39fbb9d252ee79b88d68cf677785ddc7d24313ab073f7f29d92da85af0294544b231e5772fb73584fa6d1e37b8fc9d6aace629d575b91db7ab970
e9529d1892960dbaf572bacccca8bb2d97e76719eaaf3397d4973f564d9ec2aa67e367db8b3e5cbeb3c97adedafa345c46ea30f578b9debcb7a3e0e9cb40d77784bd8790ec73b6f5b462dfcfe9cfc97a7f37bf1f
2d33a5cd4980800400769b79909d296fd13c94d1bd1b32935d12e6db46ee970ed89ec387366bd6786f8b685c9d316da79add5bf60e7f498988f9a1b0c71a3b74b2d913b2ac9ad8988f9b31ba14c826a902e162cf
a779cadfa33da66a6d5dcb9b2a337ae7505bad0cead5d77e4d856ab704697df0a945d45bb51911a9d92c74cc58f2d9467b67e734e0ea7528a2f437468e4329d456702d1d27c0bc8ee57c89e6af48e04263d263e6
f61871399d2cdd9e762569ab3d5a2b8a1fa2881234e1ab348d50cda605b4d2f516d56816de74c58835664080003bb21e44d5ceec35bb87577f2a36f3add7751d95e8becae3eee9bbaeae7f579f139e1a9af4635b
ad279d5747695cbd069b9973ba40729f5ecab38b9bbb098e375a4acb8f27afcf273437c6ace59be2b7d4ce9b7371f76b575e3cbb1d1bc8cdaa965ea7ba8888e995d5a9d77a62bc7a3d25cad1c5c3ea72519c9b3b
ba28ef212f68a4f1397d170fa5c7c8f7d79b66dd5c9e8a5fd0a2090f8ece94ea4bcefa0e64c79ca3bf259e797712a9c9b3642b4c3bb351d2c98d6b3a4acb3bd3159e1ad45aaaf4810269aac77e98e2db44a7aab7
e7476ca2dce7396bc8269e843448203d0b6f12d487165c2f40d6ef3f67712b4f9be9759daa0ddd11f3de90a3bcd6ced3ab3cf9e8027813ee014dad310996416d2ea8b24d5d69494c4795d6516e45dd044f1b3fa1
556703b56175648ec535e6e7ecf3cbf02d2e7c42cbaf84e7b376d4b32f5d5ca74ef85cb6e5f1deee0bd1e3bd0f46e8b5846a27ce61ba1d5e2e4cfebb7f3fa7e03575b169cbcb7d2262ff45e54acfb1e57085d8c7
a25628cdbc6af9f7e94ca4257d0c524d328264880013402689aa1799b541b8d2ea3324a2c99a33a1c58b104ca181e8e44b05536e2c9d934baa2e44c18ef44db8b2191216097409c5941495a224a409b54bd4a728
2a5383549356aa4d4c206112e517a40b512
.....

阅读全文

0 0