Trdsql Commands

Trdsql command syntax with verified terminal examples.

Commands

7 commands for Trdsql

trdsql HTTP

Trdsql Command: Connect To Postgresql Database

trdsql -driver postgres -dsn "host=<hostname> port=<5433> dbname=<database_name>" "SELECT 1"

trdsql HTTP

Trdsql Command: Convert Json To Csv With Header Quote

trdsql -ocsv -oh "SELECT * FROM <path/to/directory/*.json>" | sed 's/\([^,]*\)/"&"/g' > <path/to/file.csv>

trdsql HTTP

Trdsql Command: Create Mysql Table From Csv

 trdsql -driver mysql -dsn "<username>:<password>@<hostname>/<database>" -ih "CREATE TABLE <table> (<column1> int, <column2> varchar(20)) AS SELECT <column3> AS <column1>,<column2> FROM <path/to/header_file.csv>"

trdsql HTTP

Trdsql Command: Interpret Json List As Table

trdsql "SELECT * FROM <path/to/file.json>::.list"

trdsql Operations

Trdsql Command: Manipulate Sql Query Multiple Csv

 trdsql -icsv -ih "SELECT <column1,column2> FROM <path/to/file*.csv> WHERE column2 != '' ORDER BY <column1> GROUP BY <column1>"

trdsql Operations

Trdsql Command: Merge Two Csv Files

trdsql "SELECT <column1,column2> FROM <path/to/file1.csv> UNION SELECT <column1,column2> FROM <path/to/file2.csv>"

trdsql Archive

Trdsql Command: Show Data From Compressed Log File

trdsql -iltsv "SELECT * FROM <path/to/access.log.gz>"

Suggest a Trdsql Command

Submit missing workflows, corrections, or verified alternatives for this tool.

FAQ

Coverage: Focused examples for common Trdsql workflows.

Verified version: current stable LTS.

Verification: Test commands in a disposable workspace and submit notes for edge cases.