Reputation
14,680
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 28 54
Newest
 Yearling
Impact
~870k people reached

May
17
comment What are the compression options for storing large amounts of text in Postgres?
from the manual: "Long strings are compressed by the system automatically" and here is a more detailed description: postgresql.org/docs/current/static/storage-toast.html
May
17
revised Excel and Oracle SQL Connection
edited tags
May
17
awarded  Yearling
May
16
revised How to interact with a foreign key in database
edited tags
May
16
comment Oracle database for learning purposes
There is no Oracle Express edition for OS-X (actually I think there is no Oracle version for OS-X at all). However you can download a VirtualBox image that contains a pre installed environment: oracle.com/technetwork/community/developer-vm/index.html#dbapp (that is however Oracle 12 - if you really need Oracle 11, then you need to download the version for Linux and install that manually in a VirtualBox environment: oracle.com/technetwork/database/database-technologies/…
May
16
revised Autovacuum on windows
spelling
May
16
revised Autovacuum on windows
added 440 characters in body
May
16
answered Autovacuum on windows
May
16
comment Oracle Equivalent of the following SQL Server syntax
What does it do?
May
15
revised limit keyword support in DB2 latest version
edited tags
May
15
comment Managing View Dependencies
Use a schema management tool like Liquibase or Flyway
May
15
comment How to work with multiple Postgres databases in psycopg2
I don't know Python, but in Postgres it's in general not possible to do cross database queries. If you need that on a regular basis (e.g. joining tables) you are better off putting everything in one database, but separate things using schemas. A possible workaround is to use a foreign data wrapper in one DB to expose the tables in the other DB - but that will be much slower than putting everything into a single DB.
May
15
revised Select lowest ID and calculate deviation from the lowest
edited tags
May
15
comment How to GRANT/REVOKE user permissions for user on Firebird 1.5?
Regarding the documentation fragmentation: if I want to find out if a feature is present in V2.5, do I need to search the language reference update for Firebird 1.0 and 1.5 and 2.0 and 2.5 or is it sufficient to only look into the update for 2.5? Are the "update manuals" cumulative?
May
15
comment Unable to grant permission on table
Then I'll repeat my question: "Did you create that account yourself? If yes how and with which privileges?" - just because a user is called root, doesn't mean he has any special privileges
May
15
comment Unable to grant permission on table
@Greenonline: no, you don't need root access to the database server. You don't even need shell access to the database server - you only need to be able to connect to the Postgres server using a SQL tool (e.g. psql)
May
15
comment Unable to grant permission on table
What do you mean with root user? By default there is no user named "root" in Postgres. Did you create that account yourself? If yes how and with which privileges?
May
14
reviewed Edit Mass update taking to long
May
14
revised Mass update taking to long
format code
May
14
comment Memory usage on select for large number of rows
It doesn't matter where psql runs - it's still a "client" to the server. Does this also happen when you use the \o command to write the output to a file? In that case psql "knows" that you don't need to display the data, maybe it takes retrieves the data more efficiently then.