Postgres - Revision history

Leo: Added categories

2020-06-14T23:53:31Z

Added categories

← Older revision		Revision as of 23:53, 14 June 2020
Line 111:		Line 111:

	}}		}}

			{{Navbox Linux}}[[Category:Linux]]
			[[Category:LinuxUtilities]]

Leo: /* Client */

2020-01-30T18:24:18Z

Client

← Older revision		Revision as of 18:24, 30 January 2020
Line 44:		Line 44:
	(4 rows)		(4 rows)
	</nowiki>		</nowiki>
			}}

	Alternatively, you can find all tables by selecting from {{code\|pg_catalog.pg_tables}}.		Alternatively, you can find all tables by selecting from {{code\|pg_catalog.pg_tables}}.
	}}
	\|-		\|-
	\| {{code\|\c}}		\| {{code\|\c}}

Leo: /* Client */

2020-01-30T16:59:32Z

Client

← Older revision		Revision as of 16:59, 30 January 2020
Line 44:		Line 44:
	(4 rows)		(4 rows)
	</nowiki>		</nowiki>

			Alternatively, you can find all tables by selecting from {{code\|pg_catalog.pg_tables}}.
	}}		}}
	\|-		\|-

Leo: /* Client */

2020-01-30T16:36:00Z

Client

@@ Line 90: / Line 90: @@
 ...
 </nowiki>
 }}

Leo: /* Client */

2020-01-26T19:05:34Z

Client

← Older revision		Revision as of 19:05, 26 January 2020
Line 16:		Line 16:
	## -W to prompt for a password		## -W to prompt for a password
	## -h for hostname		## -h for hostname
	## ~~and~~ the database name		## -p for port
			## -d (optional) for the database name
	}}		}}

	Once in the psql console ~~databases can be listed~~ with {{code\|\l}}:		Once in the psql console, commands are issued with a backslash.

			Common commands are:
			{\|class="wikitable"
			! Command
			! Description
			\|-
			\| {{code\|\l}}
			\| Lists databases

	{{highlight\|lang=terminal\|code=		{{highlight\|lang=terminal\|code=
	<nowiki>		<nowiki>
Line 35:		Line 45:
	</nowiki>		</nowiki>
	}}		}}
			\|-
			\| {{code\|\c}}
			\| Change database

	~~A database can be selected or changed with {{code\|\c}}.~~
	{{highlight\|lang=terminal\|code=		{{highlight\|lang=terminal\|code=
	<nowiki>		<nowiki>
Line 43:		Line 55:
	</nowiki>		</nowiki>
	}}		}}
			\|-
	~~Tables can be listed with~~ {{code\|\dt}}:		\| {{code\|\dt}}
			\| Describes tables of a database.
	{{highlight\|lang=terminal\|code=		{{highlight\|lang=terminal\|code=
	citrix-confdb=# \dt		citrix-confdb=# \dt
Line 55:		Line 68:
	(3 rows)		(3 rows)
	}}		}}
			\|-
			\| {{code\|\q}}
			\| Quits the console. Same with {{code\|Ctrl+d}}
			\|-
			\| {{code\|\!}}
			\| Executes a system command. Eg. {{code\|\! ls}}
			\|-
			\| {{code\|\set}}
			\| Sets parameters in psql. Some parameters are set in {{code\|.psqlrc}}.
			\|}


	~~Records can be selected. However, if~~ the table name is in mixed case, the table name needs to be in quotes.		If the table name is in mixed case, the table name needs to be in quotes.
	{{highlight\|lang=terminal\|code=		{{highlight\|lang=terminal\|code=
	<nowiki>		<nowiki>

Leo: /* = Init DB */ format

2019-11-25T20:12:27Z

= Init DB: format

← Older revision		Revision as of 20:12, 25 November 2019
Line 1:		Line 1:

	== Tasks ==		== Tasks ==
	=== Init DB ==		=== Init DB ===
	{{highlight\|lang=terminal\|code=		{{highlight\|lang=terminal\|code=
	# service postgresql initdb		# service postgresql initdb
Line 7:		Line 7:
	Initializing database ... OK		Initializing database ... OK
	}}		}}


	== Client ==		== Client ==

Leo at 18:37, 12 November 2019

2019-11-12T18:37:45Z

← Older revision		Revision as of 18:37, 12 November 2019
Line 1:		Line 1:

			== Tasks ==
			=== Init DB ==
			{{highlight\|lang=terminal\|code=
			# service postgresql initdb
			Hint: the preferred way to do this is now "postgresql-setup initdb"
			Initializing database ... OK
			}}


	== Client ==		== Client ==

Leo at 22:17, 8 October 2019

2019-10-08T22:17:55Z

@@ Line 39: / Line 39: @@
 {{highlight|lang=terminal|code=
 citrix-confdb=# \dt
-No relations found.
+           List of relations
 }}

Leo at 22:05, 8 October 2019

2019-10-08T22:05:21Z

← Older revision		Revision as of 22:05, 8 October 2019
Line 1:		Line 1:

	== Client ==		== Client ==
	The command-line client for PosgreSQL is {{code\|psql}}. Connect by running {{code\|psql}} as root or as a particular user.		The command-line client for PosgreSQL is {{code\|psql}}. Connect by running {{code\|psql}} as root or as a particular user. Alternatively, specify the username, password, and host:

	~~Databases~~ can be listed with {{code\|\l}}:		{{highlight\|lang=terminal\|code=
			# psql -U ctxvda -W -h localhost citrix-confdb
			## -U for username
			## -W to prompt for a password
			## -h for hostname
			## and the database name
			}}

			Once in the psql console databases can be listed with {{code\|\l}}:
	{{highlight\|lang=terminal\|code=		{{highlight\|lang=terminal\|code=
	<nowiki>		<nowiki>

Leo: initial content

2019-10-08T21:56:51Z

initial content

New page

== Client ==
The command-line client for PosgreSQL is {{code|psql}}. Connect by running {{code|psql}} as root or as a particular user.

Databases can be listed with {{code|\l}}:
{{highlight|lang=terminal|code=
<nowiki>
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
---------------+----------+----------+-------------+-------------+-----------------------
citrix-confdb | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(4 rows)
</nowiki>
}}

A database can be selected or changed with {{code|\c}}.
{{highlight|lang=terminal|code=
<nowiki>
postgres=# \c citrix-confdb
You are now connected to database "citrix-confdb" as user "postgres".
</nowiki>
}}

Tables can be listed with {{code|\dt}}:
{{highlight|lang=terminal|code=
citrix-confdb=# \dt
No relations found.
}}