Sites/pyenv/versions/3.6.0/lib/python3.6/site-packages (from python-dateutil->visidata) (1.11.0) Requirement already satisfied, skipping upgrade: six>=1.5 in. Requirement already satisfied, skipping upgrade: python-dateutil in. qstr = "SELECT table_name, COUNT(column_name) AS ncols FROM information_lumns WHERE table_schema = 'antville' GROUP BY table_name"Īlthough this shows the correct list of tables, it still wouldn’t seem sufficient to somehow inject the correct schema name dynamically because of the missing nrows values ( …) – entering one of the rows shows an empty output.ġ00% |████████████████████████████████| 122kB 1.5MB/s I achieved this output by temporarily changing line 61 of loaders/postgres.py to the desired schema name: 64c64 Something along the lines of this output: table_name ‖ ncols #| nrows #‖ Trying to connect to this database with Visidata works but returns an empty set of tables – even with the persistent search_path using alter database: $ vd postgres://user: /foobar I either need to explicitely provide the schema name or set the search_path: # either one of these worksĪlter database foobar set search_path to foo # this makes it persistent I maintain a Postgres database having a non-public schema, i.e. This specs are useful in example for one of the most used opensource open data portal platform ( CKAN), and are used as official input and output format in data.world and in kaggle. If VisiData were a Data Packages reader and writer the number of users and stakeholder would increase significantly, because this is a big open data theme and many users of this world would be interested. There is a Python module to manage (reading and writing) Data Packages This spec solve big problems strictly related to structured text files (especially CSV and TSV), as lack of metadata, lack of info about separators and text qualifiers, lack of info about field types, ecc. "Data Packages" is the specification core of Open Knowledge Foundation "Frictionless Data" project. This one is a big proposal, I think it's also a great idea (I will seem presumptuous) unfortunately I am not able to help you in a concrete way. Many thanks to numerous other contributors, and to those wonderful users who provide feedback, for helping to make VisiData the awesome tool that it is. Īnja Kefala maintains the documentation and packages for all platforms. VisiData is conceived and developed by Saul Pwanson. If you use VisiData regularly, please support me on Patreon! LicenseĬode in the stable branch of this repository, including the main vd application, loaders, and plugins, is available for use and redistribution under GPLv3. If you have a question, issue, or suggestion regarding VisiData, please create an issue on Github or chat with us at #visidata on. Intro to VisiData Tutorial by Jeremy Singer-Vine.Quick reference (available within vd with Ctrl+H), which has a list of commands and options.Plugin Author's Guide and API Reference.Hundreds of other commands and options are also available see the documentation.
0 Comments
Leave a Reply. |