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.
>
>