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
How to run any project with ease

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

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/phpPgAdmin/

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
Cisco Complete Network Certification Training

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
IT, Stop Being Called Into Every Meeting

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-PHP-PDO-Query (https://www.experts-exchange.com/questions/28938256/Handling-ZERO-Results-in-a-PHP-PDO-Query.html)

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
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Databases
    (53,341)
  2. MySQL Server
    (46,194)
  3. Query Syntax
    (47,108)
  4. Linux
    (64,151)
  5. PHP
    (116,821)
  6. MS SQL Server
    (156,095)
  7. Oracle Database
    (77,650)
  8. Java
    (98,456)
  9. Linux Distributions
    (26,811)
  10. MS SQL Server 2005
    (71,399)