Porting From Oracle To PostgreSQL PostgreSQL Database Tutorial eBook PDF File Download

PDF File Topics

Our Partners

Home » Database » PostgreSQL » Porting From Oracle To PostgreSQL

Porting From Oracle To PostgreSQL

Category : Database » PostgreSQL

Source : www.cs.cmu.edu | Size : 217255

If you are starting to use PostgreSQL or you will migrate from Oracle database . Oracle and PostgreSQL both conform to standard SQL. .

Download File Free PDF eBooks Download Database PostgreSQL

Content Summary :

If you are starting to use PostgreSQL or you will migrate from Oracle database server, I hope this document helps. If you have Java applications and use JDBC, the “Data types and JDBC” section will be particularly useful. Oracle and PostgreSQL both conform to standard SQL. However, they contain several extensions and implementation details that differentiate one from the other. The most important differences are listed in this document. • The set of operators and SQL functions is very similar though Oracle has a richer set. For example, both DBMS have the concatenation operator “||”, as well as substr , upper , to_char and other functions with the same syntax. However, any Oracle function that is being used must have its syntax compared to the equivalent function in PostgreSQL, if such exists. • PostgreSQL lacks the ability to query across multiple databases.

Favorite PostgreSQL PDF File

122

Conversion Of Microsoft SQL ASP Applications To PostgreSQL

category Database » PostgreSQL

install and use a new PostgreSQL server the first is the database program. . 5 By default PostgreSQL only supports 100 concurrent connections if you need .

150

PostgreSQL 7 2 Tutorial

category Database » PostgreSQL

by The PostgreSQL Global Development Group . simple introduction to PostgreSQL relational database concepts and the SQL . PostgreSQL offers substantial .

111

PostgreSQL for Solaris How To Guide

category Database » PostgreSQL

The PostgreSQL How to Guide instructs Solaris system administrators and database . PostgreSQL database using the Solaris Service Management Facility SMF and .