Want to append the data from CSV file to the existing PostgreSQL table via command line on Linux (Ubuntu/RedHat/CentOS…)? Using pg-cmd, a Command-Line client for PostgreSQL, you can append CSV/TSV/TXT data into existing PostgreSQL table easily and fast. Support Windows, Linux, and ... Read more
Tag Archives: PostgreSQL
Append CSV data to PostgreSQL table via command line on Windows
Want to append the data from CSV file to the existing PostgreSQL table via command line on Windows? Using pg-cmd, a Command-Line client for PostgreSQL, you can append CSV/TSV/TXT data into existing PostgreSQL table easily and fast. Support Windows, Linux, and MacOS. Download pg-cmd Windows ... Read more
Batch import RTF files into PostgreSQL BYTEA (BLOB) without programming
Want to batch import RTF (Rich Text Format) documents into PostgreSQL TEXT (CLOB) or BYTEA (BLOB) column? Using PGLobEditor, you can import bulk rtf files into PostgreSQL TEXT (CLOB) or BYTEA (BLOB) easily and fast, just a few mouse clicks. Here you can download and install PGLobEditor. Batch ... Read more
Some ETL (Extract-Transform-Load) tools for PostgreSQL
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
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