Postgresql - Revision history

Jfreier at 14:28, 11 May 2026

2026-05-11T14:28:31Z

2024-11-04T19:56:31Z

2023-07-21T16:25:38Z

2023-07-07T20:25:34Z

2023-07-07T15:46:54Z

2023-04-19T20:36:35Z

2023-04-19T20:33:42Z

2023-01-19T19:41:08Z

2020-12-17T18:13:59Z

2019-09-10T19:45:57Z

‎Issues

← Older revision		Revision as of 14:28, 11 May 2026
Line 102:		Line 102:
	Then refresh the buffer using		Then refresh the buffer using
	:e		:e
		+
		+	== PSQL Sequence ==
		+	To update the sequence to a new value.
		+	SELECT setval('sequence_name', 100);

← Older revision		Revision as of 19:56, 4 November 2024
Line 87:		Line 87:
	from table_a		from table_a
	fetch first 10 rows only;		fetch first 10 rows only;
		+
		+
		+	== PSQL VIM ==
		+	Tips for editing script and running them in th PSQL command.
		+
		+	1. Edit a script in vim. Once logged in use the following command.
		+	\e
		+
		+	2. Multiple windows.
		+	In 1 window connect using the psql tool and run scripts using the following command.
		+	\o ./sql.out \i ./test.sql
		+
		+	In 2 window using VIM, edit the test.sql file and open a new tab of sql.out.
		+	Then refresh the buffer using
		+	:e

← Older revision		Revision as of 16:25, 21 July 2023
Line 81:		Line 81:
	FROM information_schema.columns		FROM information_schema.columns
	WHERE table_name='TABLE_A';		WHERE table_name='TABLE_A';
		+
		+	== Top 10 rows ==
		+	This is to get the top 10 rows.
		+	select *
		+	from table_a
		+	fetch first 10 rows only;

← Older revision		Revision as of 20:25, 7 July 2023
Line 73:		Line 73:
	Added the following line and then restarted Postgres.		Added the following line and then restarted Postgres.
	host all all 10.225.41.95/24 md5		host all all 10.225.41.95/24 md5
		+
		+	== Describe a table ==
		+	You can query the 'information_schema.columns' table to find internal table information.
		+
		+	This is a sample command to find information about a table.
		+	SELECT table_name, column_name, data_type
		+	FROM information_schema.columns
		+	WHERE table_name='TABLE_A';

@@ Line 50: / Line 50: @@
    psql
    ALTER USER 'testdb' WITH PASSWORD 'testdb';
 == Run file and commands from CLI ==

← Older revision		Revision as of 20:36, 19 April 2023
Line 18:		Line 18:

	FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com.		FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com.
		+
		+	If you are not using the system registered database you can all simply use the following commands.
		+
		+	pg_ctl -D ./data start
		+	pg_ctl -D ./data stop

	== Initialize a database directory ==		== Initialize a database directory ==

← Older revision		Revision as of 20:33, 19 April 2023
Line 18:		Line 18:

	FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com.		FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com.
		+
		+	== Initialize a database directory ==
		+	To initialize a database directory use the following command.
		+
		+	initdb -D <data_directory>

	== Environment Path ==		== Environment Path ==

← Older revision		Revision as of 19:41, 19 January 2023
Line 25:		Line 25:
	PATH=$PATH:$POSTGRESQL_HOME/bin		PATH=$PATH:$POSTGRESQL_HOME/bin

		+
		+	== Debian ==
		+	You can start Postgres in Debian using
		+	/etc/init.d/postgresql start
		+
		+	Create a database and user
		+	sudo su - postgres
		+	createdb testdb
		+	createuser testdb
		+
		+	To create a password for the user either use
		+	createuser testdb --pwprompt
		+	or
		+	psql
		+	ALTER USER 'testdb' WITH PASSWORD 'testdb';

	== Run file and commands from CLI ==		== Run file and commands from CLI ==

← Older revision		Revision as of 18:13, 17 December 2020
Line 18:		Line 18:

	FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com.		FYI, haven't tried but look like a nicer app to control Postgres is https://postgresapp.com.
		+
		+	== Environment Path ==
		+	To add PostgreSQL in to your environment path.
		+
		+	export POSTGRESQL_HOME=/Library/PostgreSQL/11
		+	PATH=$PATH:$POSTGRESQL_HOME/bin
		+
		+
		+	== Run file and commands from CLI ==
		+	PSQL will ask for your password every time unless you set it as an environment variable.
		+	export PGPASSWORD=Password123
		+
		+	To run a command.
		+	psql -U user_name -d database_name -c "SELECT * FROM tblExample"
		+
		+	To run a file.
		+	psql -U user_name -d database_name -f ./file.sql

	== Issues ==		== Issues ==

@@ Line 26: / Line 26: @@
 location of file: ./data/pg_hba.conf
-Added the following line
+Added the following line and then restarted Postgres.
    host    all             all             10.225.41.95/24        md5