
PostgreSQL
rocksword
这个作者很懒,什么都没留下…
展开
-
Postgres ERROR: database “dev” is being accessed by other users
If you are having issues dropping a postgres database the issue is more than likely that a user is accessing the database you are attempting to drop. There isn’t technically a way to force drop the po转载 2014-03-13 20:26:30 · 1300 阅读 · 0 评论 -
PostgreSQL与MySQL命令的使用比较
服务启动: 1)#service postgresql start 2)#/etc/init.d/postgresql start 3)#su postgresql $ pg_ctl startPostgreSQL的进程号:1210、1207、服务启动: 1)#service mysqld start 2)#/et转载 2014-04-23 10:55:14 · 296 阅读 · 0 评论 -
postgresql命令行
连接数据库, 默认的用户和数据库是postgrespsql -U user -d dbname切换数据库,相当于mysql的use dbname\c dbname列举数据库,相当于mysql的show databases\l列举表,相当于show tables\dt查看表结构,相当于desc tblname,show columns from tbname\转载 2014-04-23 10:37:16 · 292 阅读 · 0 评论 -
Migrate data from MySQL to PostgreSQL
1. Export data from MySQL$mysqldump -u root -p -c db_name table_name >table_name.sql原创 2014-04-23 14:10:08 · 382 阅读 · 0 评论