Use this format...

declare @sql varchar(8000)

declare @path varchar(8000)

set @path ='d:\import.psv'

select @sql = 'bcp "set fmtonly off select * from db_name.DBO.table_name" queryout '+@path+' -c -t^ -T -S' + @@servername

exec master..xp_cmdshell @sql

this will give u the Psv format with tab delimiter..