随笔分类 - postgreSQL
摘要：what we have?iRedMail -> http://iredmail.comGet the script over there. http://www.iredmail.com/download.htmlHere we use ubuntu14.04 as server.Just...
阅读全文
摘要：PostgreSQL数据的导出导入导出PostgreSQL数据库中的数据：$ pg_dump -U postgres -f mydatabase.sql mydatabase导入数据时首先创建数据库再用psql导入：$ createdb newdatabase$ psql -d newdatabas...
阅读全文
摘要：For location based service, I try to use postgresql with postgis.You can download postgis from here.http://postgis.net/sourceIt is recommended that yo...
阅读全文
摘要：原文地址：http://www.ruanyifeng.com/blog/2013/12/getting_started_with_postgresql.html期间，作者有写错的地方，已经做更改了。除了纯净的命令行来操作外，还可以使用pgadmin3 可视化工具来操作。我尝试了一下，感觉非常不错。结...
阅读全文
摘要：SQLAlchemy TrialThis is a great ORM ( Object-Relational Mapper ) which is compatible with xxxx and many others.SQLAlchemy 0.8 Documentationlink: http://docs.sqlalchemy.org/en/rel_0_8/orm/examples.html IMPORTANT TO GO THROUGHObject Relational Tutorialhttp://docs.sqlalchemy.org/en/rel_0_8/ 需要看...
阅读全文
摘要：sudo apt-get install postgresql-9.1out put :)Installation Finished. :)Please read the official reference about how to use PostgreSQLhttp://www.postgresql.org/docs/9.1/interactive/tutorial-createdb.html____________su rootsu - postgres#log into postgrespsql -U posgresthen we get into the postgreSQL co
阅读全文
摘要：to handle posgreSQL well.i found this article may be helpful.From: http://www.cnblogs.com/tzp_8/archive/2012/11/08/2760746.htmlpostgresql 常用命令（1）用户实用程序：createdb 创建一个新的PostgreSQL的数据库（和SQL语句：CREATE DATABASE 相同）createuser 创建一个新的PostgreSQL的用户（和SQL语句：CREATE USER 相同）dropdb 删除数据库dropuser 删除用户pg_dump 将Postg
阅读全文
