Skip to content
  • Home
  • Contact

Category: PostgreSQL

Pass Array To Postgres Function

PHP PostgreSQL Example – Pass Array To Postgres Function

April 8, 2016April 8, 2016 adminPHP

Today I will show you how to pass array to Postgres Function using php. First we will create a table named country that has two columns id and name. You can run the below query to create the table. CREATE TABLE country ( id serial NOT NULL, name character varying(100), CONSTRAINT country_pkey PRIMARY KEY (id) […]

pivot table

Pivot Table Creation In PostgreSQL

January 26, 2016January 26, 2016 adminPostgreSQL

In this post I will show you how to get data as pivot table in PostgreSQL. That is we will make the row values to appear as columns. Pivot table is a data summarization tool which is used to summarize data and display the result as another table. First we will create a table with […]

PostgreSQL inserting grouped result into two tables

PostgreSQL Inserting Grouped Result Into Two Tables

January 17, 2016January 17, 2016 adminPostgreSQL

In this post I will show you how to insert a grouped result from a table into two separate table, into a master table and then into its detail table. For example I will take the below example, where I will create the table ‘temp_detail’ which has the data that should be grouped. First we […]

Split function in PostgreSQL (PostgreSQL window function)

October 22, 2015November 17, 2015 adminPostgreSQL

In this post I will show you how to get date as ‘from date’ and ‘to date’ from the same column in table. We can use split function in PostgreSQL (PostgreSQL window function) to split column into two. First we will create a new table for our example. We can use pgAdmin for creating tables and […]

nth largest value from group in PostgreSQL

October 22, 2015October 22, 2015 adminPostgreSQL

In this post I will show you how to use window function in PostgreSQL to find the nth largest value from every group. You can use pgAdmin tool to create the database. First open the pgAdmin tool from start menu. After that from the object browser on the left side under Servers select ‘localhost’. Right click […]


Get more stuff like this
in your inbox

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

we respect your privacy and take protecting it seriously

Categories

  • Blogging (6)
  • Business Christmas Cards (1)
  • Business Intellegence (3)
  • Email Marketing (2)
  • IDE (3)
  • Mobile (1)
  • PHP (4)
  • Plugins (4)
  • PostgreSQL (5)
  • SEM (1)
  • SEO (10)
  • Webhosting (1)
  • WordPress (3)
  • Yii (8)
2015 © Data Byte Bank | Privacy Policy | Terms of Use
Show Buttons
Hide Buttons