Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Articles & Videos
PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.
Can vcenter 6 be installed and used with SQL 2012?
As of right now, vcenter is using the default (postgres) I believe DB that was installed during the vsphere 6 install.
Update_Manager and SRM w…
Iam new to PostGress SQL , I need to write a batch script in windows to take backup . The script should accept the date as an input and take the backup for that day.
Iam sorry , Iam asking…
I have the code above that outputs:
Client id Insurance
My report will contain the person's id, # of rows, insurance and todays date
In my database person number 22 may contain
Therefore in my report I want it to view as…
I'm migrating some small php pages from Postgress 8.4.11/PHP 5.3.3 to Postgres 9.2.5/PHP 5.4.16, and I've fixed most of the issues relating to changing from DB to MDB2, but I can't get any database up…
There is a weird issue while retrieving data using linked server connection for postgres table with a pgnp driver in SSMS
A new column with datatype double precision was added to postgres ta…
I use the following url to access my phpPgAdmin installed within xampp:
This was working perfectly on my windows machine until today
The url now gives me :
I am trying to ensure that database contains only capital letters
Can this be specified at the database level so that even if lower case characters are
entered , the database stores it as capital
I'm looking for a solution to integrate a PostgreSQL database in my google docs spreadsheet.
My database consists of about 20 or so tables, some with several thousand rows.
The database is const…
I have a view in SQLserver which works perfectly and now
need to have the same view in PostgreSQL
The view in SQLServer has UNIONS and involves about 5 tables (Attached in the notepad file)
Please advise if we can automate postgres backups on windows and move it to linux box.
I have a table in PostgreSQL it has (Amongst others) a Date , Time and TimeStamp without time zone columns
What is the syntax for updating the timestamp column from the Date and Time columns?
postgres version 9.5
level of my knowledge - novice to both postgresql and sql
The below code below that is commented out works.
And I would like to use variables to hold string infor…
I will need to grant read only access to a specific user for a database in a Postgresql database server. (9.2)
This user should be able to have all the read only access to everything.…
I have just installed postgresql on linux ubuntu server
I tried to modify postgresql.conf and pg_hba.conf
When i restarted the postgresql i got the error below
Invalid IP mask "md5" N…
I have installed ora2pg and it works on Linux servers and gets the output ,
But unfortunately i am setting up another server, all the installation went well.
output.sql file has not exported anyt…
I'm Trying to create a view PostgreSQL where I select from my Table where date = past 7 or 14 days
Can Someone help with the Syntax?
Do I need to create 2 views or can I pass it either 7 …
My application is a VB6 application running
against either a SQLServer or PostgreSQL database
I use Datagrid in the application
In SQLServer I am able to enter data into the grid and when it…
I have the following script:
It looks for all the databases named jobs_* and it should just output everything, but unfortunately I do not get any return from the execute statement.
How to grant a non superuser right to perform bulk insert transactions in postgres?
I'm working in AWS Redshift and trying to load a table without duplicates. Usually I would use a distinct, group by, or even rank to accomplish this but I have an additional requirement that …
I have an accounting application written in VB6
It runs perfectly against SQLSERVER.
In particular when i have posted I need to turn a bit field on ( that the transaction is posted)
Hi this is follow on from Handling-ZERO-Results-in-a
The code bellow is representat…
Hi I have a PDO connection to a PostgreSQL database
How do I run a Full back query if the Preffered query has zero results
I’m doing something like this
Is this the best way to do…
Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I bega…