Reputation
287
Top tag
Next privilege 300 Rep.
Create tags
Badges
4 14
Newest
 Commentator
Impact
~18k people reached

  • 0 posts edited
  • 0 helpful flags
  • 25 votes cast
Apr
18
revised PostgreSQL JSON data type used as NOSQL, But VIEW as Relational Data Structure
adding more
Apr
18
asked PostgreSQL JSON data type used as NOSQL, But VIEW as Relational Data Structure
Apr
7
accepted Maximum Partitioning PostgreSQL
Mar
24
accepted Create/copy new superuser from an existing one
Mar
24
comment Maximum Partitioning PostgreSQL
I agree with everything you have stated, the only thing I really need is separation of data, each data set could be a legal entity which could (but not for all cases) require this hard separation. I thought about doing separate schemas for this but wanted to know more about partitions and if I could actually use them that small and in the numbers needed. The other requirement is the ability to search across any, all, some of the data sets, I thought partitioning might also solve this issue. Thanks for your insight on my question
Mar
23
comment Maximum Partitioning PostgreSQL
@DanielVérité I agree but I need to somehow separate the records, I was thinking partitioning would solve this but then again it might not
Mar
23
asked Maximum Partitioning PostgreSQL
Mar
7
comment Create/copy new superuser from an existing one
how could I check for user-specific settings for userX? @dezso JoshKupershmidt
Mar
7
comment Create/copy new superuser from an existing one
I don't want to alter userX in any way, I need to clone everything userX is to another user
Mar
6
asked Create/copy new superuser from an existing one
Feb
27
awarded  Commentator
Feb
27
comment query to find all dblink()
You should also add this as an answer, it helped as well
Feb
27
accepted query to find all dblink()
Feb
27
comment query to find all dblink()
Thanks a combination of grep and this helped my efforts!
Feb
23
asked query to find all dblink()
Sep
29
awarded  Notable Question
Sep
14
awarded  Popular Question
Aug
27
comment SQL Query Formatter
Have you tried jetbrains.com/dbe
Aug
27
revised SQL Query Formatter
adding update
Aug
1
comment LISTEN / NOTIFY privileges
I just wanted to know if things have changed since this was answered. Were you able to implement something?