PostgreSQL Database Forum

Hello, I have a query in MySQL and I want to use it in Postgresql 9.3 but some functions don't exist in Postgresql! The code is this: CAST(CONCAT(TIMESTAMPDIFF(HOUR, ss.datahoralimite, ss.datahorasuspensaosla), 'h', TIMESTAMPDIFF(MINUTE,...

INSERT INTO tablename SELECT a.*, ((CASE WHEN Nullif(Trim(a.f1),'NULL') is null or trim(a.f1) = '' THEN 'f1 IS NULL;' ELSE '' END)|| (CASE WHEN Nullif(Trim(a.f2),'NULL') is null or trim(a.f2) = '' THEN 'f2 IS NULL;' ELSE '' END)|| (CASE WHEN Nullif(Trim(a.f3),'NULL') is null or trim(a.f3) = '' THEN 'f3 IS NULL;' ELSE '' END ) AS...

I have written one etl process to load data from a csv file to a target table in postgresql xtreme, the flow is like this file work tabl staging table---> exception/dups table | | target table

I'm using this to create a view for duplicates , but no of records coming out of this view are more than I'm passing in: can anybody help ? CREATE VIEW test AS ( SELECT field1, field2, field3,field4, field5 , field6,

I am using Postgresql in VS 2013 and C#. I use this for the reading of just one row by primary key. string p has the users id it must look for in the table. cn.Open(); selectSql = "SELECT user_id,user_name,user_password,user_administrator FROM userlogon WHERE user_id ='" + p + "'"; cmd.CommandText = selectSql;

I have live and some local server, The total database size in live server is around 90 GB which holds plenty of records, but one of my local server database size is around 105 GB which hold much less data then the live, as I investigate there is a table Audittrial Log Line which occupies around 104 GB and remain objects just hold 1 GB, I run...

I have some sophisticated error trapping using NpgsqlException. But many of my SQL reads are in Postgresql and use PgSqlException for error trapping. So, instead of using: catch (PgSqlException ex) { MessageBox.Show(ex.ToString()); } I want to use catch (NpgsqlException ex)

im trying to join 3 views out of which one view is not having any data. In this case, the entire query is running infinitely.

Hello, I have created one function which create dynamically pivot table .Now I want to return that table from function. Generally we return table with fixed number of columns with data type, But now I don know no of columns.Table will create dynamically and want to return that table. What should I do? Please suggest.

---------------------------------------------------------- HOT STANDBY OF MULTIPLE CLUSTERS - POSTGRESQL ---------------------------------------------------------- ##################################################################################### This document contain steps to create hot...

I want some expert help, like you. I want to add more than one row into table using function, but unable to pass F1(thebook book) as. Kindly assist if any solution. ---------------- CREATE TABLE book (

Select Host_name() Equivalent Query in Postgres.

A table has 400 columns. While inserting data into this table, We are getting the error - "could not extend file "base/../..": File too large". After that, we vacuumm'ed and reindex'ed the table and insert worked fine. Disk space is fine. Please suggest.

Hi Friends, I am using coreos operating system coreos version 1068.8.0 Docker version 1.10.3, build 3cd164c psql (PostgreSQL) 9.5.3 I need to check postgresql replication docker based between 2 servers like one as master and remote machine as slave.

Hi,In my migration script while I am using mysqldump to dump my MySQL database and PostgreSQL COPY command to copy the data files to PostgreSQL db, I am getting error cause of the newline in the fields Mysqldump command: Mysqldump –u username -p --no-create-info --skip-triggers --skip-comments --fields-terminated-by =,...

Please share the equivalent command for ON COMMIT REFRESH in Postgresql

0 down vote favorite I have installed PostgreSQL Server 9.6.0 and Python 3.4.2 on Windows 2012 R2 Server. I copied plpython3.dll to C:/Program Files/PostgreSQL/9.6/lib/ The in PostgreSQL I try running this command: CREATE EXTENSION plpython3u; And I receive this message:

Hi All, Can we create sub directories in a database with same tables. I need to create yearly wise sub directory and store the yearly wise data in different directories. Is it possible in postgreSQL ? Thank You Shijo S Philip

I use a statistical program that runs on PostgreSQL v9.3 and among it many features it allows user to create our own custom statistics, there´s a se of statistics that i need but unfortunally this statistical software developer didnt thought they were that important as to add it columns to the cache so it performance is really bad...is there a...

We are looking to migrate our DB from oracle to postgresql DB. Current oracle setup is as follows: 1. OLTP application with 95% writes 2. Production is on a Oracle RAC cluster 3. Most of the tables are partitioned What we are curreltly exploring is postgresXL cluster (equivalent of our Oracle RAC, so that we can create a 3 data node...

The Postgresql 8.3 had a dblink to Oracle. When I am trying to import the dump of 8.3 into 9.5, errors come up whenever the dblink has been used. How do I setup the DBlink in 9.5 to mirror that of 8.3 ?

I am using postgres 9.5 for my production environment and enabled Archival for basebackup, from last one week I am getting high volume of WAL log generation from simple Update, Delete and Insert queries. What are the parameters which I can tune in postgresql.conf file for this server to reduce WAL logs, sometime it is generating 300GB in a hr. ...

Hi All, I tried to find steps to install Postgresql in RHEL7 , but couldnt succeed. Please check attached , i downloaded tar ball from postgreSql official site . They say its for advanced users and i am asked to install Postgresql using that only. Regards, Ankit

Hello Friends , I am new by using PGAdmin3 tool.I am trying to add greenplum database server in pgAdmin3 . but I am not able to understand the service name for greenplum. please Answer for it. Thanks!

PostgreSQL server failed to start. I would appreciate any helpful suggestions on how to get PostgresSQL working again I have OpenERP version 6 (which works with PostgresSQL) installed on my Ubuntu 12.04.3 server and it has been working for the past few years until I did a recent server restart. When I try to start my OpenERP, I get the...