On Tue, Aug 30, 2011 at 11:26 PM, Adarsh Sharma <adarsh.sha...@orkash.com> wrote: > Dear all, > > Today I am researching about fetching all the table names in a particular > database. > There is \dt command but I need to fetch it from metadata. > I find some commands as below : > > 1. SELECT table_name FROM information_schema.tables WHERE table_schema = > 'public'; > > 2. SELECT tablename FROM pg_tables WHERE tablename NOT LIKE ‘pg%’ AND > tablename NOT LIKE ‘sql%’. > > But I need to specify a particular database & then fetch tables in that.
Try this, start psql with the -E switch, then run \d and copy and edit the query(s) that gives you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
