THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » PostgreSql   (RSS)
Showing page 2 of 2 (16 total posts)
  • Learning PostgreSql: old versions of rows are stored right in the table

    PostgreSql features multi-version concurrency control aka MVCC. To implement MVCC, old versions of rows are stored right in the same table, and this is very different from what SQL Server does, and it leads to some very interesting consequences. Let us play with this thing a little bit, but first we need to set up some test data. Setting ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on November 7, 2013
  • Learning PostgreSql: overloading

    Functions in PL/PgSql can be overloaded, which is very different from T-SQL. Demonstrating overloading For example, the second CREATE FUNCTION in the following script does not replace the first function - it creates a second one: CREATE OR REPLACE FUNCTION public.GetQuoteOfTheDay(someNumber INTEGER)RETURNS VARCHAR ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on November 5, 2013
  • Learning PostgreSql: bulk loading data

    In this post we shall start loading data in bulk. For better performance of inserts, we shall load data into a table without constraints and indexes. This sounds familiar. There is a bulk copy utility, and it is very easy to invoke from C#. The following code feeds the output from a T-SQL stored procedure into a PostgreSql table: using (var ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on November 4, 2013
  • Learning PostgreSql: Functions and refcursors

    In this post we shall create a function that returns data, and invoke it from our C# client. There are no stored procedures in PostgreSql, only functions. This is different from T-SQL, but consistent with many other languages, such as C#. Creating a function Functions can return many different types. Learning all the available options might take ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on November 1, 2013
  • Learning PostgreSql: Reading and Writing From .Net

    In this post we shall do some setup tasks, save a few rows of data from a .Net client to PostgreSql, and read it back. Setting up We have set up a virtual machine running Red Hat Linux, installed PostgreSql 9.3 on it, and made sure there is enough disk space. 9.3 is a very recent version, released this September. Because PostgreSqlis not known ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on October 31, 2013
  • Learning PostgreSql: First Steps

    In this series of blog posts we shall migrate some functionality from SQL Server to PostgreSql 9.2. The emphasis of these blog posts will be on what PostgreSql does differently from Sql Server - I assume that the reader has considerable knowledge of Sql Server, but might know nothing of PostgreSql. Also we shall concentrate on development, not ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on October 30, 2013
Privacy Statement