SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-21-2008, 05:47 AM
| ||||
| ||||
 Re: Desc Commnad in pgsql? I like the table and other info from psql and find I sometimes need that info in my client programs. Are there any SQL/plpgsql functions that are analogous to the psql \dt, \ds, etc. commands? For example create function d_table(table_name text) returns setof record that could be used in SQL commands in client programs? I am not concerned whether these are compatible with other RDBMS. TJ O'Donnell http://www.gnova.com > > If you're looking for ways to "describe" a table, there are two > mechanisms: > > 1. SQL standard (probably SQL:1993) describes an > "information_schema" which contains tables or views that allow > querying database metadata in a fairly standard fashion. > > PostgreSQL supports that. > > 2. Probably easier and friendlier, albeit nonportable, is to use > the psql "\d" command. > > >> >> For instance: >> \dt will list all tables >> \ds will list all sequences >> \dv will list all views >> and there's a further cast of ~20 variants for various different sorts >> of objects. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql      |
|
04-24-2008, 06:17 PM
| ||||
| ||||
| Re: Desc Commnad in pgsql? TJ O'Donnell wrote: > I like the table and other info from psql > and find I sometimes need that info in my client programs. > Are there any SQL/plpgsql functions that are analogous > to the psql \dt, \ds, etc. commands? If you start psql with the -E option it will show you the queries it used to build the response tables. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql |
Linear Mode
