| From: | Adam Witney <awitney(at)sghms(dot)ac(dot)uk> |
|---|---|
| To: | alviN <gamboa(at)infophil(dot)com>, pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: SQL list table names |
| Date: | 2003-01-07 11:03:15 |
| Message-ID: | BA406473.EB6D%a.witney@sghms.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
If you start psql like so
psql -E
Then all the SQL behind the \d type commands is displayed for you.
adam
> is it possible to execute an sql query to be able to list the tables's
> names?
> well, you can do it on psql using \dt. but im talking about the SQL
> statement, because i want to execute that query from a script.
>
> thanks.
>
>
>
> alviN
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chad Thompson | 2003-01-07 20:08:29 | Delete from right join |
| Previous Message | alviN | 2003-01-07 10:46:39 | SQL list table names |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nasair Junior da Silva | 2003-01-07 11:42:25 | Inherancing |
| Previous Message | alviN | 2003-01-07 10:46:39 | SQL list table names |