On Thu, Feb 16, 2012 at 3:49 AM, Linda Ursin <li...@heksebua.com> wrote:
> heksebua=# \dt
>
Ok, in this database:
\dt defaults
\dt users
\dt users_conf
Then:
select * from defaults where setting_key = 'version';
> 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: li...@heksebua.com
>
> Org: NO 995 578 107
>
>
> On Thu, Feb 16, 2012 at 12:45 PM, Chris Travers
> <chris.trav...@gmail.com>wrote:
>
>>
>>
>> On Thu, Feb 16, 2012 at 3:38 AM, Linda Ursin <li...@heksebua.com> 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
>> Ledger-smb-users@lists.sourceforge.net
>> 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
> Ledger-smb-users@lists.sourceforge.net
> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
