All Questions
Tagged with postgres or postgresql
4 questions from the last 7 days
3
votes
1
answer
150
views
Does SQL Server have a mechanism to recover from torn page writes like PostgreSQL's full_page_writes?
I am comparing how PostgreSQL and SQL Server protect data pages from torn writes.
PostgreSQL has a feature called full_page_writes.
On the first modification to a page after a checkpoint, PostgreSQL ...
- 1,573
1
vote
1
answer
141
views
How to avoid an "invalid locale" error when restoring a dump from Windows to Debian Linux?
Postgres 17 cluster is in Windows server in Estonian locale. Databases are defined like
CREATE DATABASE mydb
WITH
OWNER = mydb_owner
ENCODING = 'UTF8'
LC_COLLATE = 'et-EE'
LC_CTYPE ...
- 143
0
votes
1
answer
45
views
What is the name/abbreviation of the PostgreSQL dialect and how to highlight it in Markdown?
Question
I know TSQL is the SQL dialect of Microsoft dialect. However, I failed to find an equivalent for PostgresSQL. Thus I ask, what is the name/abbreviation of the PostgreSQL dialect?
My initial ...
- 103
1
vote
1
answer
39
views
Is it possible to use scientific notation to display large numbers in psql?
I have tables with very large numbers, which are entered using scientific notation (e.g. 1e100). But when in the PostgreSQL's psql client (as of 18.x), they get expanded into the full length:
# SELECT ...
- 3,850