I think you might need a script to strip the column header ?psql -c "select 1" |cat?column?----------1(1 row)On Saturday, March 3, 2012 at 10:17 PM, Bernard Fluixa wrote:
Hi there,I'm trying to make a playback of streamed sound data coming from a database. I could make the example included in documentation work (cat file.wav | sox -t wav - $@ -t raw -). However, I can't make it work with same sox options after having uploaded that same file into my PGSQL database and select it instead of a cat command.My shell script is#!/bin/bashpsql -h <HOST> -U postgres -E -t -q -d <DATABASE> -c "select <BINARY COLUM DATA> from <TABLE> " | sox -t wav - $@ -t raw -Freeswitch gives me a "sox FAIL formats: can't open input `-': WAVE: RIFF header not found" error message.Has anybody streamed data from database into Freeswitch?Thank you.Bernard_________________________________________________________________________Professional FreeSWITCH Consulting Services:FreeSWITCH-powered IP PBX: The CudaTel Communication ServerOfficial FreeSWITCH SitesFreeSWITCH-users mailing list_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org