charlesbedrosian

declare @server_name varchar(40)
declare @db_name varchar(40)
select @server_name = 'win7b', @db_name='io'

select '
BCP "DECLARE @colnames VARCHAR(max);DECLARE @tab char(1);SELECT @tab=char(9);SELECT @colnames = COALESCE(@colnames + @tab, '''') + column_name from ' + @db_name + '.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=''' + name + '''; select @colnames;" queryout HeadersOnly.csv -c -T -S ' + @server_name + '
BCP '+@db_name+'.dbo.'+name+' out TableDataWithoutHeaders.csv -c -T -S ' + @server_name + '
copy /b HeadersOnly.csv+TableDataWithoutHeaders.csv '+name+'.txt
del HeadersOnly.csv
del TableDataWithoutHeaders.csv

charlesbedrosian

require 'formula'
require 'net/http'

# This is an odd formula which adapts itself to whatever version of PHP
# is installed with the current version of OS X to install the missing
# PostgreSQL extension.
class PhpPostgresql < Formula
  homepage 'http://www.php.net/'
  # author: Samuel Cochran <[email protected]>