Want to schedule and automate PostgreSQL copy data task? Using DBCopier, a native GUI tool, you can scheduled PostgreSQL copy data task easily, just a few mouse clicks! Let computer automate repetitive PostgreSQL copy data busy work, DBCopier make our life easier! Here you can download and ... Read more
Tag Archives: PostgreSQL
Schedule and automate PostgreSQL importing XML data task
Want to schedule and automate PostgreSQL importing XML data task? Using FileToDB, a native GUI tool, you can scheduled importing XML data to PostgreSQL task easily, just a few mouse clicks! Let computer automate repetitive PostgreSQL importing XML data busy work, FileToDB make our life ... Read more
Schedule and automate PostgreSQL importing JSON data task
Want to schedule and automate PostgreSQL importing JSON data task? Using FileToDB, a native GUI tool, you can scheduled importing JSON data to PostgreSQL task easily, just a few mouse clicks! Let computer automate repetitive PostgreSQL importing JSON data busy work, FileToDB make our life ... Read more
Schedule and automate PostgreSQL exporting to Excel task
Want to schedule and automate PostgreSQL exporting to Excel task? Using DBToFile, a native GUI tool, you can scheduled exporting PostgreSQL data to Excel task easily, just a few mouse clicks! Let computer automate repetitive exporting PostgreSQL data to Excel busy work, DBToFile make our life ... Read more
Schedule and automate PostgreSQL exporting to files task
Want to schedule and automate PostgreSQL exporting to files task? Using PGToTxt, you can scheduled exporting PostgreSQL data to files task easily, just a few mouse clicks! Here you can download and install PGToTxt. Schedule and automate PostgreSQL exporting to files task 1. Select and run a ... 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
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