You will need to use a postgres login with suffecient permissions to view the table - login sql-ledger should be OK as it is a DB superuser. Take care as you can easily damage things.
Regards Jean-Pierre _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Jean-Pierre Guillou Director DCDM Management Services Ltd Tel PABX : (230) 202 3000 Tel Direct : (230) 202 3057 Fax : (230) 208 0086 eFax : (44) 7006 030 893 Web :www.dcdm-ms.com ******************************************************************** Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivering the message to the intended recipient), you should not read it, nor copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply E-mail. Opinions, conclusions and other information in this message that do not relate to the official business of any member firm of the DCDM Organisation shall be understood as neither given nor endorsed by the firm. On 19 July 2011 14:00, Quan Ly Hang Hoa <[email protected]> wrote: > Thank you! > When I click on the button, appears in the new window the message: ERROR: > permission denied for relation warehouse. > How i can fix? > thank you verry much. > > > > 2011/7/19 Jean Pierre Guillou <[email protected]> > >> Hi >> >> Use PgAdmin III - Click on the databse name, select Schemas, Public, >> Tables >> Go down to warehose and highlight >> >> At top of screen you will see an action button (little bit like a blank >> spreadsheet) - floating text says 'View data in selected object' - Click on >> button and data appears in new window. >> >> Works on all tables >> >> Regards >> >> Jean-Pierre >> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ >> /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >> Jean-Pierre Guillou >> Director >> DCDM Management Services Ltd >> >> Tel PABX : (230) 202 3000 >> Tel Direct : (230) 202 3057 >> Fax : (230) 208 0086 >> eFax : (44) 7006 030 893 >> Web :www.dcdm-ms.com >> ******************************************************************** >> Privileged/Confidential Information may be contained in this message. If you >> are not the addressee indicated in this message (or responsible for >> delivering the message to the intended recipient), you should not read it, >> nor copy or deliver this message to anyone. In such case, you should destroy >> this message and kindly notify the sender by reply E-mail. Opinions, >> conclusions and other information in this message that do not relate to the >> official business of any member firm of the DCDM Organisation shall be >> understood as neither given nor endorsed by the firm. >> >> >> On 19 July 2011 13:10, Quan Ly Hang Hoa <[email protected]> wrote: >> >>> Hi all! >>> In postgresql, how i can see the *aa.warehouse_id*? >>> Thank you. >>> >>> _______________________________________________ >>> SQL-Ledger mailing list >>> [email protected] >>> http://lists.ledger123.com/mailman/listinfo/sql-ledger >>> >>> >> >> _______________________________________________ >> SQL-Ledger mailing list >> [email protected] >> http://lists.ledger123.com/mailman/listinfo/sql-ledger >> >> > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger > >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
