heksebua=# \dt
public | partscustomer | table | ledgersmb
public | partsgroup | table | ledgersmb
public | partstax | table | ledgersmb
public | partsvendor | table | ledgersmb
public | pricegroup | table | ledgersmb
public | project | table | ledgersmb
public | recurring | table | ledgersmb
public | recurringemail | table | ledgersmb
public | recurringprint | table | ledgersmb
public | shipto | table | ledgersmb
public | sic | table | ledgersmb
public | status | table | ledgersmb
public | tax | table | ledgersmb
public | taxcategory | table | ledgersmb
public | taxmodule | table | ledgersmb
public | transactions | table | ledgersmb
public | translation | table | ledgersmb
public | vendor | table | ledgersmb
public | vendortax | table | ledgersmb
public | warehouse | table | ledgersmb
public | yearend | table | ledgersmb
(47 rows)
heksebua=# \dn
List of schemas
Name | Owner
--------------------+----------
information_schema | postgres
lsmb_13fail | postgres
pg_catalog | postgres
pg_toast | postgres
pg_toast_temp_1 | postgres
public | postgres
(6 rows)
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Linda Ursin
Heksebua
Adresse: Tlf: (+47) 402 40 767
Solvang www: http://heksebua.com
7288 Soknedal E-post: [email protected]
Org: NO 995 578 107
On Thu, Feb 16, 2012 at 12:45 PM, Chris Travers <[email protected]>wrote:
>
>
> On Thu, Feb 16, 2012 at 3:38 AM, Linda Ursin <[email protected]> wrote:
>
>> postgres=# \dn
>> List of schemas
>> Name | Owner
>> --------------------+----------
>> information_schema | postgres
>> pg_catalog | postgres
>> pg_toast | postgres
>> pg_toast_temp_1 | postgres
>> public | postgres
>> (5 rows)
>>
>> Try connecting to your ledgersmb database and repeat the \dt and the \dn
> tests.
>
> you can do this with psql -U postgres dbname or once in psql \c dbname
> (substitute dbname with your database name)
>
> If unsure psql -U postgres -l
>
>
> ------------------------------------------------------------------------------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> _______________________________________________
> Ledger-smb-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
