Reputation
15,480
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 29 58
Newest
 Caucus
Impact
~991k people reached

Jul
29
revised MySQL Matching records across tables discrepancies
edited tags
Jul
29
comment How Do you add multilanguage support in oracle 12c post installation?
What exactly do you want to achieve? Get error messages in a non-english language?
Jul
29
comment Selecting the correct database engine
@miracle173: of course Postgres is an RDBMD (actually an ORDBMS)
Jul
29
comment Best Admin Tool for Postgres
You forgot to mention that Postgres Enterprise Manager is a commercial product and is not an open source tool (which is what Jeevitha is looking for)
Jul
29
comment insert value based on check constraint on another column
There is no mentioning of an array in your question (and an array is still storing multiple values in a single column). You need to add some sample data and a description on how the system should behave with the sample data. As it stands I for one have no idea what you are trying to achieve.
Jul
29
comment Selecting the correct database engine
Postgres fits your list. It has an extremely efficient key/value store, supports JSON (even indexing JSON documents) and has very good SQL support (far better than the mentioned MySQL)
Jul
29
comment Best Admin Tool for Postgres
psql comes to mind. An extensive list is here: wiki.postgresql.org/wiki/…
Jul
29
revised Best Admin Tool for Postgres
edited tags
Jul
29
revised DEFERRABLE INITIALLY DEFERRED in postgres after migration
edited tags
Jul
29
comment insert value based on check constraint on another column
Do not store multiple (comma) delimited values in a single column. Normalize your model instead
Jul
29
revised insert value based on check constraint on another column
deleted 8 characters in body
Jul
28
revised Finding all date ranges that overlap a target date range
edited tags
Jul
28
comment Finding all date ranges that overlap a target date range
If you are limited to Oracle and SQL Server you should not have stated that the "choice of RDBMS is not fixed". Btw: Postgres does qualify as a "standard DBMS". Postgres range types are extremely efficient and powerful. Neither Oracle nor SQL Server has anything like that (including unique constraints on them)
Jul
28
revised pgAdmin export line overflow on large field
edited title
Jul
28
comment Row with latest timestamp
wiki.postgresql.org/wiki/Slow_Query_Questions
Jul
28
comment Remote connection to oracle database 12c
Sorry I can't see your computers from over here and my crystal ball is broken so I can't see what you did, nor how you configured your Oracle instance, nor how you configured your notebook, nor how your teammates connect to your laptop, nor how your network is setup.
Jul
28
comment Remote connection to oracle database 12c
What happened when "they" tried?
Jul
28
revised pgAdmin export line overflow on large field
edited tags
Jul
28
comment pgAdmin export line overflow on large field
The truncation of the value is not done by Postgres, but by pgAdmin (the client application). Other SQL clients might be better at this. I don't use pgAdmin, but I recall other questions regarding this, and I think there is an option somewhere that limits the amount of data displayed to the user. pg_dump can create a valid plain SQL dump for this.
Jul
28
answered How can i get list of postgresql database through php or using just sql query?