Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 148208

All versions of PostgreSQL. Add an additional version-specific tag like postgresql-11 if that context is important.

3
votes
1answer
I have a database for which the comments on objects (PSQL command COMMENT) are just pollution for us: they are obsolete and in a language that no one reads in our organisation. Hence, I'd like to dele …
asked Dec 21 '18 by Darth Kangooroo
2
votes
2answers
My problem is for Postgresql 10 but it probably is also relevant for other DB systems. I have several tables in which I need to identify groups based on several criteria (some of them are PostGIS …
asked Aug 21 '18 by Darth Kangooroo
0
votes
Partial answer, based on comments from Colin 't Hart and Евгений Ноздрев If the criterion for grouping rows is a field or a formula that will return a field-like value (numeric, text), it is possibl …
answered Aug 22 '18 by Darth Kangooroo
0
votes
Based on Daniel's answer, I have created the following script to test it works properly (it does, thanks Daniel) and to illustrate for others how to do it : -- Creating original data set DROP TABLE I …
answered Dec 17 '18 by Darth Kangooroo
1
vote
3answers
For test purposes, I want to create data sets (tables) where the statistic distribution of the values in the columns is the same as my actual data, but randomized. Example : consider the following ta …
asked Dec 16 '18 by Darth Kangooroo
1
vote
1answer
I have a PostgreSQL 10 script for which I would like to declare variables once at the beginning and then use them throughout the script (with possible transactions). I know I can do: DO $$ DECLARE …
asked Aug 2 '18 by Darth Kangooroo
1
vote
On Linux, the user postgres must have the right to read the files and execute the directories. It also needs a restart of the PSQL server.
answered May 31 '18 by Darth Kangooroo
1
vote
2answers
I had a query that was taking way too much time despite having all the indexes I could think of. Eventually, I realized that one of the JOIN .. ON inside the query was casting a column's content to a …
asked Jun 4 '18 by Darth Kangooroo
2
votes
2answers
I don't understand why the following query is so slow (with Postgresql 9.6): SELECT s.pkid AS pkid_site , s.geom AS geom_site , z.pkid AS pkidEmprise, z.geom AS geom_emprise, z.précision_contour …
asked Jun 6 '18 by Darth Kangooroo
1
vote
1answer
I am trying to define a plpgsql function in Postgresql 10 with several parameters, including an array. I have already defined the function CREATE OR REPLACE FUNCTION mix_table_fields …
asked Dec 17 '18 by Darth Kangooroo