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.

Related Topics

  1. Databases
  2. MySQL Server
  3. Query Syntax
  4. PHP
  5. Linux
  6. Microsoft SQL Server
  7. Oracle Database
  8. Java
  9. Linux Distributions
  10. .NET Programming
Refine results

Hi,

I found this command for solving the lock file "postmaster.pid" already exists in postgresql
You could stop your server doing :

pg_ctl -D /usr/local/var/postgres stop

Where did the …

17 views
Windows Server 2016: All you need to know
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

I am using Navicat and I (finally) have Postgresql running.

I accept defaults as
Record delimiter LF
Text qualifier " (there aren't any - maybe there should be)

(CODE)

So I make both date …

959 views

Hi,

   I have installed Postgresql 9.6.1 in my desktop machine.If i open the pgadmin it show error"Failed to connect to the pgAdmin application server. Click here to try again."
    After click …

1010 views

I had this question after viewing Installing Navicat postgreSQL on a local Mac (https://www.experts-exchange.com/questions/27206594/Installing-Navicat-postgreSQL-on-a-local-Mac.html).

Anyone know …

219 views

SQL Novice here. Mac 10.12.13 I have Postgres installed as the one that comes with mac and Navicat on 14 day trial. Not worked out how to use either., but these are not my questions.

This is, can …

820 views

Hello World.
After searching I am surprised there doesn't seem to be any discussion about this.
I have navicat with two days remaining on trial. I have no idea if it suits me or not, being a …

546 views

Continued from here  (https://www.experts-exchange.com/questions/29004649/Awk-Pythagoras-applying-csv-file-data-to-the-problem.html?anchor=a42033886&notificationFollowed=185186068#a42033886) because …

1432 views

Simple question and I still can not find exact answer anywhere on the web.

So I have Jira system. It's not big (20 users). It uses PostgreSQL database. Can I use pg_dump while the system is online?…

338 views

Hello,

I got a Database link from Oracle 10gR2 to Postgre 9.5 and i'm having an issue when trying to run a few commands.

I executed a few queries from pl/sql and it works sometimes but sometimes…

763 views

I had this question after viewing Backup and Restore VCenter Linux Appliance methods and scenario best practice ? …

673 views
VMware Disaster Recovery and Data Protection
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Do we have any techniques or tools to convert ER to Activity diagram.
If so, how?

227 views

I have a VB .Net application which talks to a backend PostgreSQL database.
I'm using NpgSQL to run queries against that database.

In order to get better performance for bulk inserts into the …

170 views

Hi,

For a small company, I would like to find a simple inventory management software. Requirements:
- easy to use
- web client
- MySQL/PostgreSQL storage

Nice to have:
- phone client/app
- …

7107 views

I create "idprice" field and I want to reuse it is it possible

[Err] ERROR:  column "idprice" does not exist

(CODE)

241 views

The database has about 4.5 million rows across 16 tables.
I ran the script below in the Query Tool under Views and is succeeded in 3 seconds.
I then clicked on address_view and then View Data and …

258 views

I ran this script and it appeared to run correctly apart from one line:

--

ALTER TABLE ADDRESS_ALIAS ADD
 CONSTRAINT ADDRESS_ALIAS_PK PRIMARY KEY (address_alias_pid);

ALTER TABLE …

274 views

Hi there ,
Does anyone know if you can look into whether we can do the following on the stock control page in wordpress searches of stock:
They are using a vehicle search here …

8120 views

worktime  
09:01
09.00
09.30
09.35



how can I  select  from 09:00   to   09:29 become a  
and  09:30 to 09:35  become a

result
worktime         timenote
09:01                a

478 views

Generally speaking, it is better to make lots of frequent queries on a db (that pull a small amount of data), or less frequent queries on the db (that pull a large amount of data).   I don't want to …

183 views
Free Tool: Postgres Monitoring System
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

In code line 14   i want to put table name into  field   filname   but this code put all column in each row to filed  filname  how cani fixit

(CODE)

2102 views

This line
trunc(EXTRACT(hour from "public".pong8_maintable."timestamp8") / 7)   as sectionid

make column type double precission but i want only integer how can i change it

(CODE)

7111 views

Hi:

I've got a C# method that, during it's course of execution, is running several queries using npgsql.
I have several queries to gather data from different sources (tables), and then a query to …

3118 views

I have something like this:

ResultSet rs = stmt.executeQuery("SELECT lid, basistime, value FROM fcstheight WHERE lid = 'ASTF1' ORDER BY basistime");

I need to put pass in a Java Array (or, …

2385 views

the code below when i put table name it work then i put variable name  {TabName}  it does not work how can i fix it

Parse error: syntax error, unexpected 'scriptcase' (T_STRING) in C:\Program Files…

581 views

I use navicat import cvs to postgresql    why it is not   CREATE TABLE public.AH
but it do CREATE TABLE public."AH"

then when I select     must be public."AH"   some table I import with navicat. …

379 views
Show more content
201506-LO-Top-001

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.

Related Topics

  1. Databases
  2. MySQL Server
  3. Query Syntax
  4. PHP
  5. Linux
  6. Microsoft SQL Server