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

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

210 views
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

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

28 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 http://ballinacampers.…

865 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
09.0…

423 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 o…

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

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

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

342 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, Array…

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

530 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!

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

329 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'

343 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 = 0…

14118 views

(CODE)

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

436 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 "  " )…

439 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) …

374 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 anoth…

549 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,
AD.STREET_LOCALITY…

334 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 L…

1034 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

I had this question after viewing postgresql problem - script to create tables does not run (https://www.experts-exchange.com/questions/28975169/postgresql-problem-script-to-create-tables-does-not-run…

753 views

In postgresql 9.6 (running under Windows 7 64),  I attempted to run a script to create tables but it showed this error:

ERROR:  table "street_locality_point" does not exist
********** Error ******…

838 views

Hello,

What are the options for replicating postgresql database between two data centers for DR? (Active/Standby setup for DCs)

Thank you for your help.

J

443 views

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…

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

447 views

(CODE)

I have the code above that outputs:

Client id           Insurance
------------           ---------------
123                    AA
123                    EE
123                       …

1858 views
Show more content
201506-LO-Top-001
Top Experts In
PostgreSQL
<
Monthly
>

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Databases
    (53,501)
  2. MySQL Server
    (46,367)
  3. Query Syntax
    (47,304)
  4. PHP
    (117,296)
  5. Linux
    (64,383)
  6. MS SQL Server
    (156,711)
  7. Oracle Database
    (77,868)
  8. Java
    (98,639)
  9. Linux Distributions
    (26,854)
  10. MS SQL Server 2005
    (71,488)