Withdata software has announced pgtotxt 1.0, a data conversion tool that export PostgreSQL data to flat file (csv, xml, html, sql) and excel. PGToTxt 1.0 if the first release version. PGToTxt – The better tool to export PostgreSQL data to file PGToTxt is convenient: 1. Easy visually config, ... Read more
Author Archives: Shiji Pan
Withdata Software Released XlsToSqlite Version 1.0
Withdata software has announced xlstosqlite 1.0, a data conversion tool that import Excel data to SQLite database. XlsToSqlite 1.0 is the first release version. XlsToSqlite – A better tool for importing Excel data to SQLite XlsToSqlite is convenient: 1. Easy visually config, just click on ... Read more
Withdata Software Released XlsToPG Version 1.0
Withdata software has announced xlstopg 1.0, a data conversion tool that import Excel data to PostgreSQL database. XlsToPG 1.0 is the first release version. XlsToPG – A better tool for importing Excel data to PostgreSQL XlsToPG is convenient: 1. Easy visually config, just click on the ... Read more
Withdata Software Released TxtToPG Version 1.0
Withdata software has announced txttopg 1.0, a data conversion tool that import csv(txt) data to PostgreSQL database. TxtToPG 1.0 is the first release version. TxtToPG – A Better Way to import CSV(TXT) data to PostgreSQL TxtToPG is convenient: 1. Easy visually config, just click on the ... Read more
Withdata Software Released Tail4win Version 4.6
WITHDATA SOFTWARE has announced Tail4win 4.6, a windows port of the UNIX ‘tail -f’ command. Tail4win 4.6 add global Highlight and Filter, and improve utf8 and unicode encoding support. Tail4win – Windows Tail. Tail4win is convenient: 1.Highlighting and filtering(as “tail ... Read more
Withdata Software Released TxtToSqlite Version 1.0
Withdata software has announced txttosqlite 1.0, a data conversion tool that import csv(txt) data to SQLite database. TxtToSqlite 1.0 is the first release version. TxtToSqlite – A Better Way to import CSV(TXT) data to Sqlite TxtToSqlite is convenient: 1. Easy visually config, just click on ... Read more
How to execute sql file via command line for PostgreSQL
Use psql psql -U username -d myDataBase -a -f myInsertFile More information: http://blog.manoharbhattarai.com.np/2013/04/03/execute-sql-file-from-command-line-in-postgresql/ ... Read more
How to execute sql file via command line for Oracle
Use sql*plus run SQL file sqlplus username/password@databasename @/path/to/test.sql If you want to see whats going on like this, including any error messages, you need connect to SQL*Plus with sqlplus username/password@databasename Then run the script from the SQL*Plus prompt: set echo ... Read more
How to execute sql file via command line for DB2
You can save a .sql file to your hard drive, and execute it using the DB2 command line using: db2 -vtf C:\path\to\test.sql -v echoes the command text back to the command line -t sets the statement terminator to ;. -f tells the command line to load the commands from the file. See other command ... Read more
How to execute sql file at SQL Server command line
You can use sqlcmd to run a Transact-SQL script file. A Transact-SQL script file is a text file that can contain a combination of Transact-SQL statements, sqlcmdcommands, and scripting variables. To run the script file 1.Open a command prompt window. 2.In the Command Prompt window, ... Read more