using the ucsc mysql server:

$ mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -D hg19  -N -e 'select chrom,txStart,txEnd,name2,strand from refGene ' 

chr19    20115226    20150277    ZNF682    -
chr17    40274755    40275371    HSPB9    +
chr1    34610    36081    FAM138A    -
chr6_qbl_hap6    2882090    2899191    PRRC2A    +
chr3    10327433    10334631    GHRL    -
chr2    220378891    220403494    ASIC4    +
chr17    18086866    18113267    ALKBH5    +
chr1    1658823    1677438    SLC35E2    -
chr1    700244    714068    LOC100288069    -
chr11    129872518    129875381    LINC00167    +

Hi Deedee,

If you change you selection of output file from "BED browser extensible file" to "Selected field from primary and related tables"and then choosing the fields you want in you output file.

Step 1: Selected field from primary and related tables

Step 2: choosing the fields you want in you output file:

This is the way you can do it from web browser tool. I hope this helps.

So, from the 2nd image, in the output format, select the option selected fields from primary and related tables then get output and then from the list, select the name2 checkbox for alternate names and whatever other attributes you want.

List looks like

bin  
name    Name of gene (usually transcript_id from GTF)
chrom   Reference sequence chromosome or scaffold
strand  + or - for strand
txStart Transcription start position
txEnd   Transcription end position
cdsStart    Coding region start
cdsEnd  Coding region end
exonCount   Number of exons
exonStarts  Exon start positions
exonEnds    Exon end positions
score    
name2   Alternate name (e.g. gene_id from GTF)
cdsStartStat    enum('none','unk','incmpl','cmpl')
cdsEndStat  enum('none','unk','incmpl','cmpl')
exonFrames  Exon frame {0,1,2}, or -1 if no frame for exon

Cheers