How to query the names of all user-defined data tables in a database in PostgreSQL

How to query the names of all user-defined data tables in a database in PostgreSQL

@ Forandever 2011-11-13

1. query through command line
\ D database-- Obtain the names of all tables.
\ D table name-- Get the table structure
 
2. query through SQL statements
"Select * From pg_tables"-- Obtain information about all tables in the current database (pg_tables is the system view here)

"Select tablename from pg_tables where schemaname = 'public '"-- Obtain the names of all user-defined tables (here, the "tablename" field is the table name, and "schemaname" is the schema name. If the user-defined table is not specially processed, it is put under the schema named public by default)

@ For & ever 2011-11-13