Withdata software has announced mssqltopostgres 1.0, a data conversion tool that convert SQL Server data to PostgreSQL database. Version 1.0 is the first release. MsSqlToPostgres – Convert SQL Server data to PostgreSQL MsSqlToPostgres is convenient: 1. Easy visually config, just click on ... Read more
Tag Archives: PostgreSQL
Withdata Software Released DB2ToPostgres Version 1.0
Withdata software has announced db2topostgres 1.0, a data conversion tool that convert DB2 data to PostgreSQL database. Version 1.0 is the first release. DB2ToPostgres – Convert DB2 data to PostgreSQL DB2ToPostgres is convenient: 1. Easy visually config, just click on the mouse. 2. ... Read more
Withdata Software Released AccessToPostgres Version 1.0
Withdata software has announced accesstopostgres 1.0, a data conversion tool that convert Access data to PostgreSQL database. Version 1.0 is the first release. AccessToPostgres – Convert Access data to PostgreSQL AccessToPostgres is convenient: 1. Easy visually config, just click on the ... Read more
How to View PDF stored in PostgreSQL BYTEA field
Some time you need view pdf stored in PostgreSQL bytea field, how to do it? I suggest you try PGLobEditor, you can download it form here: http://www.withdata.com/down/PGLobEditor.exe . Run PGLobEditor, execute query, and click the “BLOB” grid that contains PDF data. then you’ll ... Read more
Withdata Software Released Withdata PostgresToExcel 1.0
Withdata software has announced withdata postgrestoexcel 1.0, a data conversion tool that export PostgreSQL data to excel. Withdata PostgresToExcel 1.0 is first release version. Withdata PostgresToExcel – Export PostgreSQL data to Excel Withdata PostgresToExcel is convenient: 1. Easy ... 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 limit the number of rows returned by a PostgreSQL query
In MySQL, you can use “Limit <skip>,<count>”, like this: select * from sometable order by name limit 20,10 How to do in PostgreSQL? You’d use “Limit <count> offset <skip>”, like this: select * from sometable order by name limit 10 offset ... Read more
Replace Update or Insert a row Into PostgreSQL Table
In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. How to do it in PostgreSQL? A way to do an “UPSERT” in postgresql is to do two sequential ... Read more