Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

With the mysql shell, you can get vertical output when executing interactive queries by ending them with \G instead of ;.

For example:

mysql> select * from foo limit 1\G
*************************** 1. row ***************************
      sid: foo
    login: bar
1 row in set (0.00 sec)

Is it possible to do the same using fisql from FreeTDS?

Alternatively, I will accept an answer that can recommend a better UNIX-compatible command line interface to SQL Server that has this capability.

Thanks!

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

I just discovered sqsh which seems to do the trick:

$ sqsh -S server:1433 -U sa  
sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
Password: 
1> select * from sys.databases where name = 'master'
2> go -m vert
name:                           master
database_id:                    1
source_database_id:             NULL
owner_sid:                      0x01
...

(1 row affected)
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.