Click here to Skip to main content
15,311,151 members
Home / Discussions / Database
   

Database

 
AnswerRe: Get all tables under a database in Postgre Pin
Richard MacCutchan13-Jan-22 23:39
mveRichard MacCutchan13-Jan-22 23:39 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 0:06
Member_Flaviu14-Jan-22 0:06 
GeneralRe: Get all tables under a database in Postgre Pin
Richard MacCutchan14-Jan-22 0:13
mveRichard MacCutchan14-Jan-22 0:13 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 3:32
Member_Flaviu14-Jan-22 3:32 
QuestionList all tables from a specific database Pin
_Flaviu12-Jan-22 0:41
Member_Flaviu12-Jan-22 0:41 
AnswerRe: List all tables from a specific database Pin
Peter_in_278012-Jan-22 1:18
professionalPeter_in_278012-Jan-22 1:18 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 1:35
Member_Flaviu12-Jan-22 1:35 
AnswerRe: List all tables from a specific database Pin
k505412-Jan-22 1:35
mvek505412-Jan-22 1:35 
You can get Postgres to tell you how to do that using the -E (display hidden queries) option to psql. So for example
Shell
$ psql -E -l
********* QUERY **********
SELECT d.datname as "Name",
       pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
       pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",
       d.datcollate as "Collate",
       d.datctype as "Ctype",
       pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges"
FROM pg_catalog.pg_database d
ORDER BY 1;
<hr />

                                  List of databases
   Name    |  Owner   | Encoding  |   Collate   |    Ctype    |   Access privileges   
-----------+----------+-----------+-------------+-------------+-----------------------
 template0 | postgres | UTF8      | en_CA.UTF-8 | en_CA.UTF-8 | =c/postgres          +
           |          |           |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8      | en_CA.UTF-8 | en_CA.UTF-8 | =c/postgres          +
           |          |           |             |             | postgres=CTc/postgres
 test      | ebacon   | UTF8      | en_CA.UTF-8 | en_CA.UTF-8 | 
(3 rows)
Likewise for the
\dt<dt> command inside psql.  Then all you need to do is to figure out how to combine both queries into one.<br />

<div class="signature">Keep Calm and Carry On</div></dt>

GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 1:59
Member_Flaviu12-Jan-22 1:59 
GeneralRe: List all tables from a specific database Pin
k505412-Jan-22 4:13
mvek505412-Jan-22 4:13 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 4:32
Member_Flaviu12-Jan-22 4:32 
GeneralRe: List all tables from a specific database Pin
Richard MacCutchan12-Jan-22 4:39
mveRichard MacCutchan12-Jan-22 4:39 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 5:19
Member_Flaviu12-Jan-22 5:19 
GeneralRe: List all tables from a specific database Pin
Richard MacCutchan12-Jan-22 5:41
mveRichard MacCutchan12-Jan-22 5:41 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 6:16
Member_Flaviu12-Jan-22 6:16 
GeneralRe: List all tables from a specific database Pin
Richard MacCutchan12-Jan-22 6:43
mveRichard MacCutchan12-Jan-22 6:43 
QuestionWampServer localhost Pin
_Flaviu6-Jan-22 6:59
Member_Flaviu6-Jan-22 6:59 
AnswerRe: WampServer localhost Pin
Graham Breach6-Jan-22 21:10
MemberGraham Breach6-Jan-22 21:10 
GeneralRe: WampServer localhost Pin
_Flaviu6-Jan-22 23:53
Member_Flaviu6-Jan-22 23:53 
QuestionSQLite sqlite_schema missing Pin
_Flaviu4-Jan-22 4:20
Member_Flaviu4-Jan-22 4:20 
AnswerRe: SQLite sqlite_schema missing Pin
Richard Deeming4-Jan-22 4:40
mveRichard Deeming4-Jan-22 4:40 
GeneralRe: SQLite sqlite_schema missing Pin
_Flaviu4-Jan-22 7:16
Member_Flaviu4-Jan-22 7:16 
GeneralRe: SQLite sqlite_schema missing Pin
_Flaviu4-Jan-22 7:17
Member_Flaviu4-Jan-22 7:17 
QuestionDate and Time Add Incompatibility between sql 2012 and sql 2018 Pin
Medo-I23-Dec-21 7:42
MemberMedo-I23-Dec-21 7:42 
AnswerRe: Date and Time Add Incompatibility between sql 2012 and sql 2018 Pin
Richard Andrew x6423-Dec-21 8:56
professionalRichard Andrew x6423-Dec-21 8:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.