| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tariq Muhammad <tmuhamma(at)libertyrms(dot)com> |
| Cc: | Dan Delaney <ddelaney(at)powercreative(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Dealing with schema in psql utility? |
| Date: | 2003-02-21 04:23:33 |
| Message-ID: | 9627.1045801413@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tariq Muhammad <tmuhamma(at)libertyrms(dot)com> writes:
> On Thu, 20 Feb 2003, Dan Delaney wrote:
>> 1) get a list of the schema that have been created in the current
>> database
> select * from pg_namespace ;
7.4 psql will also offer "\dn". We didn't get around to making this
happen for 7.3.
>> 2) View the list of tables in a schema other than "public"?
Try "\dt myschema.*"
>> 3) Rename a schema (is there an "alter schema" statement)?
On the to-do list, but not done yet. As Tariq says, an ALTER command
will serve for the moment.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Deepa | 2003-02-21 05:28:18 | Re: Creating index does not make any change in query plan. |
| Previous Message | John DeSoi | 2003-02-21 04:01:11 | cursors and column names |