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
Tag Archives: PostgreSQL
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