chrisj wrote:
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
You might try
psql dbname -Atc "select * from tableX where whatever" > tableX.dat
to produce un-aligned output, if this is your problem.
Brent Wood
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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
