PostgreSQL Database Forum

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.

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.

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)

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

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

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

I have Oracle query which needs to be converted into postgresql . In oracle query i have NLS_DATE_LANGUAGE='Italy' parameter set. What is the equivalent code to read the italy date values in postgresql.

We need to fetch multiple records from a table using select POSTGRESQL SQL query and need to highlight the record(row) with red or green color based on a condition. Is the above requirement is feasible. Please help us to achieve this task.

I keep getting this error within my application duplicate key value violates unique constraint "product_supplierinfo_pkey" DETAIL: Key (id)=(409) already exists. The actual next sequence number the key constraint needs to be is 5461 not 409. It is a postgreSQL table called product_supplierinfo and it has a constraint called...

CREATE OR REPLACE VIEW vwstmACC AS SELECT DISTINCT ON (stmnt.chargeservicelineid) stmnt.created, stmnt.createdby, stmnt.lastupdated, stmnt.updatedby, stmnt.accountid, stmnt.practiceid, stmnt.chargegroupid, stmnt.chargeservicelineid, stmnt.patientid, stmnt.paymentpostingid, stmnt.chargeadjustmentid, stmnt.locationid, stmnt.specialityid,...

HI, I am developing a program for windows ce device using c#. The existing database is Postgresql. Is it possible to connect Postgresql to my windows ce program? If yes, how? Looking forward for your immediate response. Thank you.

I have been researching for days about the diff. between pltcl and plpgsql language in postgresql to solve my problem. I have created a trigger function in 'pltcl' language but now I am trying to convert this in 'plpgsql' language. Any idea on how to convert this piece of trigger function code to plpgsql function? Thanks CREATE OR REPLACE...

How to find duplicate points(poi) in an area by creating a radius for each points and compared with another points which resides in the radius, for every points it has to be follow the same method?

I am struggling to write a pl/sql function that encompasses the two below queries. Right now, the function executes, but when called it isn't returning anything.... It looks like I *might* be running into some trouble with passing $1 in a set returning function (i.e ST_Dump or generate_series...). It fails like this on a Multipolygon feature: ...

1) i'm new to postgresql. i have one package in oracle, now i need to create that package in postgresql.please give me the alternative for the packages in postgresql. 2) how to execute the procedures automatically in postgresql. like we have a package in oracle dbms_job.submit. please help me.. thanks in advance

I just want to ask if you can upload binary files (ex. jpg, doc files) to the postgreSQL server through PHP? If so, how must this be done? Just a link on any tutorial will do. Thanks!

HI Guys I need a big help from you guys. I need to install postgresql cluster on Suse Linux 11 SP1. I have found links about cluster installing on CentOS but not in Suse Linux. Can you please let me know a way or a link about installing Postgresql on Suse Linux.

Hello, I have installed postgresql on Linux on a virtual box on my wintel machine. I am unable to get a connection from pgadmin to the DB. I have modified these two files to allow remote connections to DB, then restarted the postgresql service: postgresql.conf added line: listen_addresses = '*'

Simply put, I have been storing json data in bytea's with the data encrypted. Now, I would like to take advantage of 9.3's ability to have json indexes, but presume that encryption / indexes simply won't work. If anyone knows how to do this, or can confirm that it can't be done, then please advise.

Hi, Following is my code that does some initial accounts creation in bulk for some purpose. After creating about 52 accounts it gives the following error: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already Unless I am overlooking something , I open only one database connections, making 3 SQL Statatements, 3...

i have followed this link http://www.postgresonline.com/journal/index.php?url=archives/165-Encrypting-data-with-pgcrypto.html&serendipity=moderate#feedback to perform two way encryption, but i am getting the following error while inserting : ERROR : Corrupt ascii-armor please help me to solve this error.

Hi Guys, I am new to Database and Postgresql. I created an ERD diagram to store information on students, parents, teachers and schools, part of my design instead of having address for each entity I create a new entity called address and contains a composite primary key from (studentID, partentID, techerID, schoolID), streetName, suburb,...