Withdata Software provide some ETL (Extract-Transform-Load) tools for PostgreSQL: FileToDB Load TXT, CSV, TSV, XML, JSON, Excel, SQL, RDF, INI data to PostgreSQL DBToFile Export PostgreSQL data to TXT, CSV, TSV, XML, JSON, Excel, SQL files DBCopier Copy data between PostgreSQL and ... Read more
Tag Archives: PostgreSQL
Parse RDF file and save to PostgreSQL
Want to parse RDF file and save to PostgreSQL ? Want to schedule and automate this importing task? To import Xml format RDF file (.rdf, .owl) to PostgreSQL, https://www.withdata.com/blog/rdftopostgres/postgresql-import-rdf.html To import RDF Turtle file (.ttl, .n3) to PostgreSQL, ... Read more
How to select N random records from a PostgreSQL table
If you want to select N random records from a PostgreSQL table, you need to change the clause as follows: select * from tableName order by random() limit N For example, to select 5 random customers in the customers table, you use the following query: select * from customers order by random() ... Read more
How to get index column names of a table from PostgreSQL
select i.relname as index_name, a.attname as column_name from pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace n where t.oid = ix.indrelid and i.oid = ix.indexrelid and a.attrelid = t.oid and a.attnum = ANY(ix.indkey) and n.oid=t.relnamespace and t.relkind = 'r' and ... Read more
How to get primary key of a table from PostgreSQL
SELECT pg_attribute.attname, format_type(pg_attribute.atttypid, pg_attribute.atttypmod) FROM pg_index, pg_class, pg_attribute, pg_namespace WHERE pg_class.oid = 'my_table_name'::regclass AND indrelid = pg_class.oid AND nspname = 'my_schema_name' AND pg_class.relnamespace = pg_namespace.oid ... Read more
Withdata Software Released PGLobEditor Version 1.1
Withdata software has announced pglobeditor 1.1, a tool that helps you edit PostgreSQL lob (bytea (blob), text (clob)) data directly. Version 1.1 Add “Create sub folders by field name”. Add “turning off log” in command line. PGLobEditor – Edit PostgreSQL LOB data ... Read more
Withdata Software Released PostgresToExcel Version 1.1
Withdata software has announced postgrestoexcel 1.1, a data conversion tool that export PostgreSQL data to excel. Version 1.1 Add “turning off log” in command line. Withdata PostgresToExcel – Tool for exporting PostgreSQL data to Excel Withdata PostgresToExcel is convenient: 1. ... Read more
Withdata Software Released PGToTxt Version 1.1
Withdata software has announced pgtotxt 1.1, a data conversion tool that export PostgreSQL data to flat file (csv, tsv, xml, html, sql) and excel. Version 1.1 Add “turning off log” in command line. Add an option for “replace CRLF with space”. PGToTxt – The better ... Read more
Withdata Software Released XlsToPG Version 1.1
Withdata software has announced xlstopg 1.1, a data conversion tool that import Excel data to PostgreSQL database. Version 1.1 Add “turning off log” in command line. Add “Bad File” to log failed import records. Fix bug “falied load part columns data in command ... Read more
Withdata Software Released TxtToPG Version 1.1
Withdata software has announced txttopg 1.1, a data conversion tool that import txt (csv, tsv) data to PostgreSQL database. Version 1.1 Add “Bad File” to log failed import records. Add “Exception Report From”. Improve import performance. TxtToPG – Better tool to ... Read more