Question : I started an hours-long Postgres query in my psql shell. Then, I got disconnected from the network and […]
Tag: psql
How can I rerun a statement from server logs without manual editing?
Question : I have some statements in my logs like this: SELECT to_char(“version_downloads”.”date”, $1), SUM(version_downloads.downloads) FROM “version_downloads” WHERE “version_downloads”.”version_id” IN […]
Adding constraint on data
Question : I created a table called customer, which consists of one attribute called email. Then I would like to […]
.psqlrc – setting keepalives_idle connection parameter
Question : Is it possible to set keepalives_idle parameter in .psqlrc so that every connection I open uses it? I’ve […]
How do you use psql client to connect to a postgresql ipv6 host?
Question : # postgresql.conf listen_addresses=’::’ and # pg_hba.conf hostssl webdb webserver ::0/0 cert The postgresql server is running on docker […]
Why ‘t’ and ‘f’ instead of TRUE and FALSE
Question : Why does PostgreSQL return ‘t’ and ‘f’ instead of TRUE and FALSE? The documentation itself advises us to […]
Postgres copy from CSV: how to format range variables?
Question : Consider a Postgres table containing a range variable: CREATE TABLE my_table (t_range tsrange, field1 text); If I want […]
CREATE SEQUENCE using expressions with psql variables for parameters
Question : I’ve been playing with Postgres for a week or so and I’m seeing if it’s possible to set […]
Unique index on multiple columns vs single column index
Question : I have a table in the following structure. Now from a data integrity standpoint I want to add […]
Cannot revoke default privileges from postgresql user
Question : I am using the psql tool: Command: my_db=# ddp Result: Default access privileges Owner | Schema | Type […]