For When You Can't Have The Real Thing
[ start | index | login ]
start > postgresql > List Tables In Databases

List Tables In Databases

Created by dave. Last edited by dave, 6 years and 235 days ago. Viewed 1,312 times. #2
[diff] [history] [edit] [rdf]
labels
attachments

Problem

List all tables in a given postgresql database:

Solution

select tablename from pg_tables;
no comments | post comment
This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful:


snipsnap.org | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt