如何开始使用类似于MySQL的PostgreSQL

Question

null

c）从命令行如何（PostgreSQL ones？）：

 mysql -uroot -proot  
   create database testdb; 
   use testdb;
   create table test(id int(11) auto_increment, name varchar(20), primary key(id));
   insert into test(name) values("testing one"),("testing two"),("testing three"),("testing four");
   select * from test;
   update test set name=concat(name,now()) where id =3;
   delete from test where id =4;
   drop table if exists test;
   drop database if exists testdb;

编辑MAC OS#默认密码重置

sudo mate /Library/PostgreSQL/9.2/data/pg_hba.conf

已替换(md5为信任）

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

 login to postgresql without password : 
  $ psql -U postgres
  postgres# ALTER USER postgres WITH PASSWORD 'new password';
  \q  

Answer 1

登录：

psql -d postgres_dbname -U postgres

创建数据库：

create database  testuser;

\c testuser;  /*use testuse as mysql*/

创建表：

create table employee (Name char(20));

 insert into employee VALUES ('XAS');