Support of Postgres for Yuneta
sudo apt-get install postgresql-server-dev-all libpq-dev
To fix this error in ubuntu 20.04 "fatal error: postgresql/libpq-fe.h: No such file or directory"
sudo apt-get install --reinstall libpq-dev
Number of rows:
select COUNT(*) from tablename;
Size in megas:
\dt+
Delete all rows:
delete from tablename;
List tables:
\dt+
Desc of table:
\d+ tablename;
See last record:
SELECT id,rowid,__created_at__ FROM tracks_purezadb order by rowid DESC limit 1; SELECT * FROM tracks_purezadb order by __created_at__ DESC limit 1;
Add new column:
ALTER TABLE tracks_purezadb ADD COLUMN noise bigint;
Cortar las conexiones:
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname ='mulesol_local';
Licensed under the The MIT License. See LICENSE.txt in the source distribution for details.