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
Tag Archives: PostgreSQL
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
Export data from PostgreSQL query to SQL file
Want to export data from PostgreSQL query to SQL file? Using DBToFile, a native GUI tool, you can export data from PostgreSQL query to SQL file easily and fast, just a few mouse clicks! Support Windows, Linux, macOS. Here you can download and install DBToFile. Export data from PostgreSQL ... Read more
Export data from PostgreSQL query to XML file
Want to export data from PostgreSQL query to XML file? Using DBToFile, a native GUI tool, you can export data from PostgreSQL query to XML file easily and fast, just a few mouse clicks! Support Windows, Linux, macOS. Here you can download and install DBToFile. Export data from PostgreSQL ... Read more
Batch export data from PostgreSQL tables to XML files
Want to batch export data from PostgreSQL tables to XML files? Using DBToFile, a native GUI tool, you can batch export data from PostgreSQL tables to XML files easily and fast, just a few mouse clicks! Support Windows, Linux, macOS. Here you can download and install DBToFile. Batch export data ... Read more
Import data from TSV file to PostgreSQL without programming
Want to import data from TSV file to PostgreSQL ? Using FileToDB, a native GUI tool, you can import data from TSV file to PostgreSQL easily and fast. Step by step, just a few mouse clicks. Avoid uploading big TSV file(s) to online services. Support large TSV files (big than 4GB). Support ... Read more
Import data from TXT file to PostgreSQL without programming
Want to import data from TXT file to PostgreSQL ? Using Withdata software FileToDB, a TXT to PostgreSQL converter, you can convert data from TXT file to PostgreSQL easily and fast. Can run in GUI mode, Step by Step, just a few mouse clicks. Can run in Command line, for Scheduled Tasks and ... Read more
Batch export data from PostgreSQL tables to JSON files
Want to batch export data from PostgreSQL tables to JSON files? Using DBToFile, a native GUI tool, you can batch export data from PostgreSQL tables to JSON files easily and fast, just a few mouse clicks! Support Windows, Linux, macOS. Here you can download and install DBToFile. Batch export ... Read more
Batch export data from PostgreSQL tables to TSV files
Want to batch export data from PostgreSQL tables to TSV files? Using DBToFile, a native GUI tool, you can batch export data from PostgreSQL tables to TSV files easily and fast, just a few mouse clicks! Support Windows, Linux, macOS. Here you can download and install DBToFile. Batch export data ... Read more
Export data from PostgreSQL query to JSON file
Want to export data from PostgreSQL query to JSON file? Using DBToFile, a native GUI tool, you can export data from PostgreSQL query to JSON file easily and fast, just a few mouse clicks! Support Windows, Linux, macOS. Here you can download and install DBToFile. Export data from PostgreSQL ... Read more