As of May 31, 2023, we have updated our Code of Conduct.

New answers tagged

0 votes

Syntax error on query submitted to the Linux C library

I'm very sorry, the problem was in my LOG1 macro :( Anyway, thanks to White Owl to confirm that there is not limit inside the driver.
SteMMo's user avatar
  • 101
1 vote

How can I get a list of locales in PostgreSQL?

PostgreSQL uses locales from either the C library or the ICU library. If you want to use C library locales, as your question suggests, you can look at SELECT collname FROM pg_collation WHERE ...
Laurenz Albe's user avatar
  • 42.6k
3 votes
Accepted

How can I get a list of locales in PostgreSQL?

Postgres uses locales provided by the underlying OS. The manual: PostgreSQL uses the standard ISO C and POSIX locale facilities provided by the server operating system. To see all available locales, ...
Erwin Brandstetter's user avatar
3 votes
Accepted

psql \set an environment variable from the existing shell environment

psql version 15 provides the \getenv metacommand to do this efficiently: \getenv psql_var env_var Gets the value of the environment variable env_var and assigns it to the psql variable psql_var. If ...
Daniel Vérité's user avatar
2 votes
Accepted

Does the order in which vms are shutdown impact the postgresql replication environment?

You can shutdown and restart primary and standby in any order you want; that won't cause a problem. However, you could get into trouble if you keep the standby server down while data modifications ...
Laurenz Albe's user avatar
  • 42.6k
3 votes
Accepted

SQL Server on LInux - OpenRowSet function only has access to files in /var/opt/mssql directory?

From here: the /proc directory is NOT a real File System, in the sense of the term. It is a Virtual File System. Contained within the procfs are information about processes and other system ...
Hannah Vernon's user avatar
  • 69.1k
0 votes

Unable to use data pump utility in Oracle to import data to another server

Data Pump runs on the database server and a Data Pump dumpfile import expects the dumpfile to be accessible on the database server, and not on the remote location where you started impdp. This is not ...
Balazs Papp's user avatar
  • 39.5k

Top 50 recent answers are included