Psql: Difference between revisions

From annawiki
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->