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

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…

731 views
Efficient way to get backups off site to Azure
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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

647 views

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

217 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 …

142 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
- …

794 views

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

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

(CODE)

227 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 …

242 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 …

248 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 …

8101 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

460 views
Microsoft Certification Exam 74-409
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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 …

172 views

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)

286 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)

787 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 …

393 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, …

2373 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…

565 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. …

365 views

(CODE)

The code above is work

But when in php  - Postgres it not work
(CODE)
date_trunc('hour', public.pong8_maintable."timestamp8") as Date_hour,       , how can I  change 'hour'

376 views

EE,

Sql 2008 R2.  Unable to Bubble user-defined Sql RAISERROR(...) to c# exception.  

Simplified example usage; a SELECT correctly returns no rows because of the WHERE clause.  IF @@ROWCOUNT = …

14167 views
What is SQL Server and how does it work?
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

(CODE)

This code work but how can I change it to print all customer not only first customer

461 views

this code is not work in postgres  when I use macro
sc_exec_sql("  sql    ")    I think problem come from "   inside " "


(CODE)

but this below i test it work   (HOW CAN i FIX " iNSIDE "  " )…

476 views

I'm pretty new to PostgreSQL and have a basic design question I'd like some advice on.

Our company has 1000+ identical schemas defined in our PostgreSQL DB. We have separate Schemas (work places) …

3124 views

This script work perfectly, and I want to include two more columns from another table. The table details are included at the end. (I want to be able to see the contents of table: mb_2011_code in …

583 views

I want to run a query to export the view to a csv file.
Here's the view query:

CREATE OR REPLACE VIEW ADDRESS_VIEW

AS

SELECT
AD.ADDRESS_DETAIL_PID as ADDRESS_DETAIL_PID,

368 views

I attempted to run this script:

CREATE OR REPLACE VIEW ADDRESS_VIEW

AS
SELECT
AD.ADDRESS_DETAIL_PID as ADDRESS_DETAIL_PID,
AD.STREET_LOCALITY_PID as STREET_LOCALITY_PID,
AD.LOCALITY_PID as …

1058 views
Show more content
201506-LO-Top-001
Top Experts In In
PostgreSQL

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Databases
    (53,700)
  2. MySQL Server
    (46,533)
  3. Query Syntax
    (47,606)
  4. PHP
    (117,724)
  5. Linux
    (64,642)
  6. MS SQL Server
    (157,558)
  7. Oracle Database
    (78,050)
  8. Java
    (98,868)
  9. Linux Distributions
    (26,896)
  10. .NET Programming
    (131,929)