THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » PostgreSql   (RSS)
Showing page 2 of 2 (19 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
  • Becoming A Better Programmer In 6 Months: The First 20 days

    Here is an update of what I accomplished in the first 20 days   Read the book lifehacker Read the book Microsoft SQL Server 2005 Integration Services Read the book  Extending SSIS 2005 with Script Read 1 chapter of Learning Python, Second Edition Played around with the July CTP of SQL Server 2008   So in the first 20 days ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on August 6, 2007
  • Becoming A Better Programmer In 6 Months: The First 10 days

    Here is an update of what I accomplished in the first 10 days   Read the book lifehacker Read the book Microsoft SQL Server 2005 Integration Services Read 126 pages of Extending SSIS 2005 with Script Installed PostgreSQL, Python, Eclipse and Django.   Now you may ask yourself how I could have read all these things in 10 days. ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on July 25, 2007
  • Log Buffer #21: A Carnival of the Vanities for DBAs

    Hello, there!  You’ve somehow managed to navigate your way through the blogosphere and into the 21st edition of Log Buffer.   It’s fitting that this is the 21st edition, because that just so happens to be the legal drinking age here in the United States. And the folks over at Oracle sure need a drink or three this week. Computerworld’s ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 1, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement