I would like to do a selective export of a number of tables from a large database to import into a smaller (test) DB. I know about: psql dbname -tc "select * from tableX where whatever" > tableX.dat but unless I put it through a sed script, this file cannot be easily used for import. It feels like I am re-inventing the wheel. Does anybody know a better way or have a good sed script. -- View this message in context: http://www.nabble.com/selective-export-for-subsequent-import-%28COPY%29-tf3604927.html#a10071704 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
