Programming/PostgreSQL/Table Queries
< Programming | PostgreSQL(Redirected from PostgreSQL/Table Queries)
Jump to navigation
Jump to search
All of the following assume you have first loaded a database.
These also require replacing <table_name>
with the actual name of the table to query.
Show Tables
\dt
Or for expanded data:
\dt+
Alternatively:
SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';
Show Extra Relational Data About Table
\d <table_name>
Show Table Indexes
SELECT indexname, indexdef FROM pg_indexes WHERE tablename = '<table_name>';
Create Table
CREATE TABLE <table_name> ( <columns> );
Where <columns>
is replaced by the actual columns desired for the table.
For example, to create a table with columns of id, name, description
, we can do:
CREATE TABLE <table_name> ( id serial PRIMARY KEY, name VARCHAR(100), description VARCHAR(100) );
Delete Table
DROP TABLE <table_name>;
Display Number of Records in Table
SELECT COUNT(*) FROM <table_name>;