Is it possible to copy data from a table into a file and specify a query for what data should be included? e.g. \copy table1 to 'data.txt' where col1=true thanks csn __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com