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
PostgreSQL
2K
Solutions
3
Articles & Videos
1K
Contributors
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.
Refine results
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…
127 views
Hi ,
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…
416 views
(CODE)
I have the code above that outputs:
Client id Insurance
------------ ---------------
123 AA
123 EE
123 …
1825 views
My report will contain the person's id, # of rows, insurance and todays date
In my database person number 22 may contain
22 UH
22 AA
22 EI
Therefore in my report I want it to view as…
1725 views
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…
1557 views
Hi,
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…
130 views
I use the following url to access my phpPgAdmin installed within xampp:
http://localhost:8080/phpP
This was working perfectly on my windows machine until today
The url now gives me :
ht…
1429 views
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
…
125 views
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…
142 views
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)
I …
538 views
If you’re an IT engineer or technician, it's time you take your career to the next level. This elite training bundle is brimming with all of the information you need to learn to sit for Cisco CNNA, CCNP, and CCENT certification exams.
Hi,
Please advise if we can automate postgres backups on windows and move it to linux box.
Thanks
1557 views
Hi
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?
330 views
postgres version 9.5
level of my knowledge - novice to both postgresql and sql
The below code below that is commented out works.
(CODE)
And I would like to use variables to hold string infor…
1263 views
Hi Experts,
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.…
154 views
Hi
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…
1262 views
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…
471 views
Hi
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 …
446 views
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…
370 views
I have the following script:
(CODE)
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.
I…
248 views
Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!
How to grant a non superuser right to perform bulk insert transactions in postgres?
151 views
Hello,
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 …
1490 views
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)
In SQLSERVE…
673 views
Hi this is follow on from Handling-ZERO-Results-in-a
The code bellow is representat…
1293 views
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
(CODE)
Is this the best way to do…
672 views
Hi Experts
Could you point what is going wrong in this MySQL/ Codeigniter form data insertion ?
Controller Code
(CODE)
Model code
(CODE)
MySQL table (auto increment)
(CODE)
Thanks…
657 views
201506-LO-Top-001
