Psql - Revision history

Tobiasco: /* Documentation */

2013-11-21T12:20:22Z

Documentation

← Older revision		Revision as of 2013-11-21T12:20:22
Line 70:		Line 70:

	* second result links to http://www.postgresql.org/docs/9.3/static/tutorial-createdb.html - no interest in tutorial. Wanted: documentation. Update: By accident found that the Tutorial is part of the documentation.		* second result links to http://www.postgresql.org/docs/9.3/static/tutorial-createdb.html - no interest in tutorial. Wanted: documentation. Update: By accident found that the Tutorial is part of the documentation.

	~~==Documentation==~~
	~~There are at least two parts labeled with a Roman number I:~~
	* http://www.postgresql.org/docs/9.3/static/sql-commands.html I. SQL Commands
	* http://www.postgresql.org/docs/9.3/static/tutorial.html I. Tutorial

	~~===I. Tutorial===~~
	~~Those who set up and manage their own server should also read Part III.~~
	Does one need to read "I" to find out that one needs to read "III" to manage an own server? If not, then isn't it superfluous is? And yes, it is in the http://www.postgresql.org/docs/9.3/static/preface.html - redundancy bloats the documentation.

	~~===1.4. Accessing a Database===~~
	~~You already discovered this scheme in the previous section using createdb.~~
	~~No. I did not.~~


	~~===II. PostgreSQL Client Applications===~~
	~~http://www.postgresql.org/docs/9.3/static/reference-client.html~~
	~~This part contains reference information for PostgreSQL client applications~~
	~~and utilities. Not all of these commands are of general utility;~~
	~~These commands? The first sentence did not contain the word "command".~~

Tobiasco: /* Documentation */

2013-11-21T12:10:54Z

Documentation

← Older revision		Revision as of 2013-11-21T12:10:54
Line 83:		Line 83:
	You already discovered this scheme in the previous section using createdb.		You already discovered this scheme in the previous section using createdb.
	No. I did not.		No. I did not.


			===II. PostgreSQL Client Applications===
			http://www.postgresql.org/docs/9.3/static/reference-client.html
			This part contains reference information for PostgreSQL client applications
			and utilities. Not all of these commands are of general utility;
			These commands? The first sentence did not contain the word "command".

Tobiasco: /* Documentation */

2013-11-21T12:02:13Z

Documentation

← Older revision		Revision as of 2013-11-21T12:02:13
Line 72:		Line 72:

	==Documentation==		==Documentation==
			There are at least two parts labeled with a Roman number I:
			* http://www.postgresql.org/docs/9.3/static/sql-commands.html I. SQL Commands
			* http://www.postgresql.org/docs/9.3/static/tutorial.html I. Tutorial

	===I. Tutorial===		===I. Tutorial===
	Those who set up and manage their own server should also read Part III.		Those who set up and manage their own server should also read Part III.

Tobiasco: /* Create DB and CREATEDB */

2013-11-21T11:53:49Z

Create DB and CREATEDB

← Older revision		Revision as of 2013-11-21T11:53:49
Line 48:		Line 48:
	But http://www.postgresql.org/docs/9.3/static/sql-createdatabase.html says		But http://www.postgresql.org/docs/9.3/static/sql-createdatabase.html says
	"To create a database, you must be a superuser or have the special CREATEDB privilege."		"To create a database, you must be a superuser or have the special CREATEDB privilege."
	Where to find "privilege"~~-listing~~?		Where to find out what "privilege" one has?
	* ~~Not~~ listed at http://www.postgresql.org/docs/9.3/static/index.html		* The word "privilege" is not listed at http://www.postgresql.org/docs/9.3/static/index.html
	* http://www.postgresql.org/search/?u=%2Fdocs%2F9.3%2F&q=privilege - the search result listing comes with little texts, the first contains " See Section 5.6 for more information about privileges."		* http://www.postgresql.org/search/?u=%2Fdocs%2F9.3%2F&q=privilege - the search result listing comes with little texts, the first contains " See Section 5.6 for more information about privileges."
	* Clicking that result leads to http://www.postgresql.org/docs/9.3/static/functions-info.html, the first result for in-page search repeats the above sentence, with hyperlink to the http://www.postgresql.org/docs/9.3/static/ddl-priv.html		* Clicking that result leads to http://www.postgresql.org/docs/9.3/static/functions-info.html, the first result for in-page search repeats the above sentence, with hyperlink to the http://www.postgresql.org/docs/9.3/static/ddl-priv.html

Tobiasco: /* Create table */

2013-11-21T11:45:44Z

Create table

← Older revision		Revision as of 2013-11-21T11:45:44
Line 31:		Line 31:
	No matching relations found.		No matching relations found.
	test->		test->

			Try with semicolon:
			test=> CREATE TABLE testtable;
			ERROR: syntax error at or near ";"
			LINE 1: CREATE TABLE testtable;

	==Create DB and CREATEDB==		==Create DB and CREATEDB==

Tobiasco: /* I. Tutorial */

2013-11-21T11:37:07Z

I. Tutorial

← Older revision		Revision as of 2013-11-21T11:37:07
Line 69:		Line 69:
	===I. Tutorial===		===I. Tutorial===
	Those who set up and manage their own server should also read Part III.		Those who set up and manage their own server should also read Part III.
	Does one need to read "I" to find out that one needs to read "III" to manage an own server? If not, then isn't it superfluous is?		Does one need to read "I" to find out that one needs to read "III" to manage an own server? If not, then isn't it superfluous is? And yes, it is in the http://www.postgresql.org/docs/9.3/static/preface.html - redundancy bloats the documentation.

	===1.4. Accessing a Database===		===1.4. Accessing a Database===
	You already discovered this scheme in the previous section using createdb.		You already discovered this scheme in the previous section using createdb.
	No. I did not.		No. I did not.

Tobiasco: /* Documentation */

2013-11-21T11:35:02Z

Documentation

← Older revision		Revision as of 2013-11-21T11:35:02
Line 67:		Line 67:

	==Documentation==		==Documentation==
			===I. Tutorial===
			Those who set up and manage their own server should also read Part III.
			Does one need to read "I" to find out that one needs to read "III" to manage an own server? If not, then isn't it superfluous is?
	===1.4. Accessing a Database===		===1.4. Accessing a Database===
	You already discovered this scheme in the previous section using createdb.		You already discovered this scheme in the previous section using createdb.
	No. I did not.		No. I did not.

Tobiasco: /* Create DB and CREATEDB */

2013-11-21T11:32:24Z

Create DB and CREATEDB

← Older revision		Revision as of 2013-11-21T11:32:24
Line 64:		Line 64:
	So, that is not the privilege "CREATEDB" here, but a wrapper? No interest in wrapper.		So, that is not the privilege "CREATEDB" here, but a wrapper? No interest in wrapper.

	* second result links to http://www.postgresql.org/docs/9.3/static/tutorial-createdb.html - no interest in tutorial. Wanted: documentation.		* second result links to http://www.postgresql.org/docs/9.3/static/tutorial-createdb.html - no interest in tutorial. Wanted: documentation. Update: By accident found that the Tutorial is part of the documentation.

			==Documentation==
			===1.4. Accessing a Database===
			You already discovered this scheme in the previous section using createdb.
			No. I did not.

Tobiasco at 2013-11-21T10:21:33

2013-11-21T10:21:33Z

← Older revision		Revision as of 2013-11-21T10:21:33
Line 1:		Line 1:
			==Connection==
			tobiasco@main:/root$ psql
			psql: FATAL: database "tobiasco" does not exist
			Who asked or claimed that?
			tobiasco@main:/root$ psql postgres
			psql (9.3.1)
			Type "help" for help.

			postgres=>
			postgres=> \c tidb_all
			You are now connected to database "tidb_all" as user "tobiasco".
			tidb_all=>
			tidb_all=>

	==Create database==		==Create database==
	tobiasco@main:/root$ psql CREATE DATABASE test2;		tobiasco@main:/root$ psql CREATE DATABASE test2;

Tobiasco: /* Create DB and CREATEDB */

2013-11-21T10:13:45Z

Create DB and CREATEDB

← Older revision		Revision as of 2013-11-21T10:13:45
Line 41:		Line 41:
	Refer to? It would be nice to have a complete list of all "different types of privileges supported by PostgreSQL". Anyway, look at http://www.postgresql.org/docs/9.3/static/sql-grant.html		Refer to? It would be nice to have a complete list of all "different types of privileges supported by PostgreSQL". Anyway, look at http://www.postgresql.org/docs/9.3/static/sql-grant.html
	* "CREATEDB" not found on that page		* "CREATEDB" not found on that page
	* Try http://www.postgresql.org/search/?u=%2Fdocs%2F9.3%2F&q=CREATEDB , first result links to http://www.postgresql.org/docs/9.3/static/app-createdb.html		* Try http://www.postgresql.org/search/?u=%2Fdocs%2F9.3%2F&q=CREATEDB
			* first result links to http://www.postgresql.org/docs/9.3/static/app-createdb.html
	createdb -- create a new PostgreSQL database		createdb -- create a new PostgreSQL database
	[...]		[...]
Line 48:		Line 49:
	createdb is a wrapper around the SQL command CREATE DATABASE.		createdb is a wrapper around the SQL command CREATE DATABASE.
	So, that is not the privilege "CREATEDB" here, but a wrapper? No interest in wrapper.		So, that is not the privilege "CREATEDB" here, but a wrapper? No interest in wrapper.

			* second result links to http://www.postgresql.org/docs/9.3/static/tutorial-createdb.html - no interest in tutorial. Wanted: documentation.