Browsed by
Category: PostgreSQL

RDBMS Data Limit ?>

RDBMS Data Limit

== Microsoft SQL Server == Max DB Size: 524,272 TB (32 767 files * 16 TB max file size) Max Table Size: 524,272 TB Max Row Size: 8,060 bytes (Unlimited) Max Columns Per Row: 30,000 Max Blob / Clob Size: 2 GB Max Char Size: 2 GB Max Number Size: 126 bits Min Date Value: 0001 Max Date Value: 9999 Max Column Name Size: 128 == MySQL == Max DB Size: Unlimited Max Table Size: MyISAM storage limits: 256 TB; Innodb storage limits: 64 TB Max Row Size:…

Read More Read More

PostGIS Enabled Schema with Different Schema Name ?>

PostGIS Enabled Schema with Different Schema Name

PLEASE MAKE SURE YOU BACKUP YOUR PUBLIC SCHEMA ! Steps: Open up pgAdmin III and connect to PostgreSQL. Select desired database and click on schemas Open up SQL Editor Open & execute public_schema.sql Open & execute public_data.sql Open rename_schema.sql and replace `new_schema_name` with the name you want, then execute the query Files can be found here: PostGIS Enabled Schema

PostgreSQL – Import data from CSV ?>

PostgreSQL – Import data from CSV

You CSV file similar to the following: The SQL: References: http://forums.enterprisedb.com/posts/list/2819.page http://dba.stackexchange.com/questions/18821/how-to-import-a-csv-file-into-a-postgresql-database-using-copy http://stackoverflow.com/questions/2987433/how-to-import-csv-file-data-into-a-postgres-table http://www.postgresql.org/docs/9.1/static/sql-copy.html http://stackoverflow.com/questions/10079682/copy-function-in-postgresql

Android – Connect to PHP ?>

Android – Connect to PHP

Search keyword: android connect to php Here, I’m going to show the simplest way to connect to the PHP in Android – receiving JSON(JavaScript Object Notation) upon successful. You could make a simple JSON response in a PHP script like the following and deploy it to the server / localhost. I’m creating a new Android project in Eclipse and extending the AsyncTask class in order to connect to PHP, and using HtppGet to make a connection to the server(can be…

Read More Read More

PostGIS – 1.5 to 2.0 ?>

PostGIS – 1.5 to 2.0

Just a note, do run ‘legacy.sql‘ when migrate from PostGIS 1.5 to PostGIS 2.0 because there’s functions being removed from 1.5. so we need it back. Reference: http://postgis.refractions.net/docs/PostGIS_FAQ.html#legacy_faq