Psql: Difference between revisions
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
==Create database== | |||
tobiasco@main:/root$ psql CREATE DATABASE test2; | tobiasco@main:/root$ psql CREATE DATABASE test2; | ||
psql: warning: extra command-line argument "test2" ignored | psql: warning: extra command-line argument "test2" ignored | ||
psql: FATAL: Peer authentication failed for user "DATABASE" | psql: FATAL: Peer authentication failed for user "DATABASE" | ||
==Create table== | |||
tobiasco@main:/root$ psql test | tobiasco@main:/root$ psql test | ||
psql (9.3.1) | psql (9.3.1) |
Revision as of 2013-11-21T10:32:12
Create database
tobiasco@main:/root$ psql CREATE DATABASE test2; psql: warning: extra command-line argument "test2" ignored psql: FATAL: Peer authentication failed for user "DATABASE"
Create table
tobiasco@main:/root$ psql test psql (9.3.1) Type "help" for help. test=> CREATE TABLE testtable test-> \dt test No matching relations found. test->