I regularly need to unload some rows from tables, and load into different
databases, sometimes on different hosts. In simple cases, I can do
something like:
psql -At -d dbname -c "select from table where...."
Due to some embedded tabs and other anomalies in our data, we then have to
pipe the output to a perl script that transforms the wierdness (like
tabs/crlf).
pg_dump handles all this perfectly, but cannot be used because it dumps an
entire table.
I read the code for pg_dump, and it appears it handles the problem by
looking at every character, less than a " ", it converts to an octal character.
Has anyone considered hacking pg_dump so I could send it a "select
....."? If not, could I please put this on the wish list?
Naomi
-- CONFIDENTIALITY NOTICE --
This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain
informationthat is privileged, confidential and exempt from disclosure under applicable law. If you are not the
intendedaddressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use,
copy,disclose or distribute to anyone the message or any information contained in the message. If you have received
thismessage in error, please immediately advise the sender by reply email, and delete the message. Thank you.