Programming/PostgreSQL/Table Queries - Revision history

Brodriguez: Minor clean up

2023-01-27T03:06:21Z

Minor clean up

← Older revision		Revision as of 03:06, 27 January 2023
Line 24:		Line 24:

	== Create Table ==		== Create Table ==
	CREATE TABLE ~~test_tables__col_str~~ (		CREATE TABLE <table_name> (
	<columns>		<columns>
	);		);


	Where {{ ic \|<columns>}} is replaced by the actual columns desired for the table.		Where {{ ic \|<columns>}} is replaced by the actual columns desired for the table.

	For example, to create a table with columns of {{ ic \|id, name, description}}, we can do:		For example, to create a table with columns of {{ ic \|id, name, description}}, we can do:
	CREATE TABLE ~~test_tables__create__success~~ (		CREATE TABLE <table_name> (
	id serial PRIMARY KEY,		id serial PRIMARY KEY,
	name VARCHAR(100),		name VARCHAR(100),

Brodriguez: Brodriguez moved page PostgreSQL/Table Queries to Programming/PostgreSQL/Table Queries

2023-01-27T01:22:29Z

Brodriguez moved page PostgreSQL/Table Queries to Programming/PostgreSQL/Table Queries

← Older revision

Revision as of 01:22, 27 January 2023

Brodriguez: Brodriguez moved page PostgresQL/Table Queries to PostgreSQL/Table Queries

2023-01-27T01:22:18Z

Brodriguez moved page PostgresQL/Table Queries to PostgreSQL/Table Queries

← Older revision

Revision as of 01:22, 27 January 2023

Brodriguez: Add descriptor

2023-01-27T01:16:37Z

Add descriptor

← Older revision		Revision as of 01:16, 27 January 2023
Line 1:		Line 1:
	All of the following assume you have first [[Programming/PostgreSQL/Databases#Load_a_Database \| loaded a database]].		All of the following assume you have first [[Programming/PostgreSQL/Databases#Load_a_Database \| loaded a database]].

			These also require replacing {{ ic \|<table_name>}} with the actual name of the table to query.

Brodriguez: Brodriguez moved page PostgresQL/Queries to PostgresQL/Table Queries

2023-01-27T01:15:37Z

Brodriguez moved page PostgresQL/Queries to PostgresQL/Table Queries

← Older revision

Revision as of 01:15, 27 January 2023

Brodriguez: Update queries

2023-01-27T01:15:18Z

Update queries

← Older revision		Revision as of 01:15, 27 January 2023
Line 38:		Line 38:
	== Delete Table ==		== Delete Table ==
	DROP TABLE <table_name>;		DROP TABLE <table_name>;


			== Display Number of Records in Table ==
			SELECT COUNT(*) FROM <table_name>;

Brodriguez: Update page

2023-01-27T01:01:12Z

Update page

@@ Line 9: / Line 9: @@
 Alternatively:
-  SELECT * FROM pg_catalog.pg_tables;
+  SELECT table_name FROM information_schema.tables
@@ Line 18: / Line 19: @@
 == Show Table Indexes ==
   SELECT indexname, indexdef FROM pg_indexes WHERE tablename = '<table_name>';

Brodriguez: Create page

2021-09-10T01:35:55Z

Create page

New page

All of the following assume you have first [[Programming/PostgreSQL/Databases#Load_a_Database | loaded a database]].

== Show Tables ==
\dt

Or for expanded data:
\dt+

Alternatively:
SELECT * FROM pg_catalog.pg_tables;

== Show Extra Relational Data About Table ==
\d <table_name>

== Show Table Indexes ==
SELECT indexname, indexdef FROM pg_indexes WHERE tablename = '<table_name>';