heksebua=# \dt defaults
List of relations
Schema | Name | Type | Owner
--------+----------+-------+-----------
public | defaults | table | ledgersmb
(1 row)
heksebua=# \dt users
No matching relations found.
heksebua=# \dt users_conf
No matching relations found.
heksebua=# select * from defaults where setting_key = 'version';
setting_key | value
-------------+-------
version | 1.2.0
(1 row)
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
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 1:11 PM, Chris Travers <chris.trav...@gmail.com>wrote:
>
>
> 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
>
>
------------------------------------------------------------------------------
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
