Postgres Create user, table

Use CreateUser to create a user

[Plain]View Plaincopyprint?

2. [Email protected] ~]$/data/pgsql/bin/createuser--help
4. CreateUser creates a new PostgreSQL role.
8. Usage:
10. CreateUser [OPTION] ... [ROLENAME]
14. Options:
16. -C,--connection-limit=n connection limit for role (Default:no limit)
18. -D,--createdb role can create new databases
20. -D,--no-createdb role cannot create databases (default)
22. -E,--echo show the commands being sent to the server
24. -E,--encrypted encrypt stored password
26. -I,--inherit role inherits privileges of roles it is a
28. Member of (default)
30. -I,--no-inherit role does not inherit privileges
32. -L,--login role can login (default)
34. -L,--no-login role cannot login
36. -N,--unencrypted do not encrypt stored password
38. -P,--pwprompt assign a password to new role
40. -R,--createrole role can create new roles
42. -R,--no-createrole role cannot create roles (default)
44. -S,--superuser role would be superuser
46. -S,--no-superuser role won't be superuser (default)
48. -V,--version output version information, then exit
50. --interactive prompt for missing role name and attributes rather
52. than using defaults
54. --replication role can initiate replication
56. --no-replication role cannot initiate replication
58. -?,--Help show this help and then exit
62. Connection options:
64. -H,--host=hostname database server host or socket directory
66. -p,--port=port database server port
68. -U,--username=username user name to connect as (not the one to create)
70. -W,--no-password never prompt for password
72. -W,--password force password prompt
76. Report bugs to <[email Protected]>.
78. [Email protected] ~]$
80. [Email protected] ~]$
82. [Email protected] ~]$/data/pgsql/bin/createuser zhongwc-p
84. Enter Password for new role:
86. Enter It again:
88. [Email protected] ~]$

Create a database using Createdb

[Plain]View Plaincopyprint?

2. [Email protected] ~]$/data/pgsql/bin/createdb--help
4. Createdb creates a PostgreSQL database.
8. Usage:
10. Createdb [OPTION] ... [DBNAME] [DESCRIPTION]
14. Options:
16. -D,--tablespace=tablespace default tablespace for the database
18. -E,--echo show the commands being sent to the server
20. -E,--encoding=encoding encoding for the database
22. -L,--locale=locale locale settings for the database
24. --lc-collate=locale lc_collate setting for the database
26. --lc-ctype=locale lc_ctype setting for the database
28. -O,--owner=owner database user to own the new database
30. -T,--template=template template database to copy
32. -V,--version output version information, then exit
34. -?,--Help show this help and then exit
38. Connection options:
40. -H,--host=hostname database server host or socket directory
42. -p,--port=port database server port
44. -U,--username=username user name to connect as
46. -W,--no-password never prompt for password
48. -W,--password force password prompt
50. --maintenance-db=dbname Alternate Maintenance Database
54. By default, a database with the same name as the current user is created.
58. Report bugs to <[email Protected]>.
60. [Email protected] ~]$
62. [Email protected] ~]$
64. [Email protected] ~]$/data/pgsql/bin/createdb zwcdb

[Plain]View Plaincopyprint?

2. [Email protected] ~]$ psql-u zhongwc-d zwcdb
4. Psql (9.2.2)
6. Type ' help ' for help.
10. Zwcdb=> Help
12. You is using Psql, the command-line interface to PostgreSQL.
14. Type: \copyright for distribution Terms
16. \h for help with SQL commands
18. \? For help with Psql commands
20. \g or terminate with semicolon to execute query
22. \q to quit
24. Zwcdb=>

Create a table

[Plain]View Plaincopyprint?

2. [Email protected] data]$ psql-u zhongwc-d zwcdb-h 192.168.1.203-p 1521
4. Password for user zhongwc:
6. Psql (9.2.2)
8. Type ' help ' for help.
12. Zwcdb=> CREATE TABLE T_ZHONGWC (PID integer,pname varchar (+), constraint ZHONGWC_PID_PK primary key (PID));
14. Notice:create table/primary KEY would CREATE implicit index "ZHONGWC_PID_PK" for TABLE "T_ZHONGWC"
16. CREATE TABLE
18. Zwcdb=>
20. Zwcdb=> select * from T_ZHONGWC;
22. PID | PName
24. -----+-------
26. (0 rows)

Delete a table

[Plain]View Plaincopyprint?

1. zwcdb=> drop table T_ZHONGWC;
2. DROP TABLE
3. zwcdb=> drop table T_ZHONGWC;
4. Error:table "T_ZHONGWC" does not exist

Postgres Create user, table