Question : Postgres 11, Windows 10, pgAdmin 4 I have a large post-gis enabled table (29million rows, 20GB + a […]
Tag: psql
How to get latest timestamped result from time series in a join table [duplicate]
Question : This question already has answers here: Get rows with most recent date for each different item (3 answers) […]
Restore postgres in command line on ubuntu failed
Question : This question may be asked many times. We are trying to move a postgres db from windows (psql […]
Display only table names with psql
Question : How can I get the table names without a header or footer or anything else from a specified […]
Database is 300 GB, but I only see small tables?
Question : I wonder why my database is so large. I type: SELECT pg_size_pretty(pg_database_size(‘defaultdb’)); and it says defaultdb is 259 […]
GRANT ALL ON ALL TABLES IN SCHEMA does not allow user to see tables
Question : I have a pretty simple script to create a new database and to create a new user to […]
How to use Italian locale for Postgres messages
Question : On Oracle I have set: export NLS_LANG=Italian_ITALY.UTF8 .. on Unix shell and now I get status and error […]
How do I synchronize parallel imports with COPY? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Insert PBKDF2 hash into PostgreSQL container
Question : I am using the PostgreSQL docker image with the following Dockerfile: FROM postgres:10.1 COPY init-db.sh /docker-entrypoint-initdb.d/init-db.sh and an […]
Column containing the word from another column
Question : I am trying to select records in a postgresql where the service column contains usernames. Something like this […]