Re: Re-2: New to PostgreSQL - looking for query writing tools

2023-02-02 Thread Jiten Kumar Shah
You can try https://github.com/OmniDB/OmniDB is not active but it is working and also available in postgres debian repo On 2/2/23 13:38, Brent Wood wrote: The free version of Valentina Studio and DBeaver are the two I prefer If you use Postgis for spatial data, DBeaver understands geometry

Re: 10.22 Windows binaries download? (zip "invalid" on Enterprisedb)

2022-09-21 Thread JITEN KUMAR SHAH
Few days before one of the user having same issue and they find out it was some file name issue Link of email: https://www.postgresql.org/message-id/CA%2BRCjax7d3djH6YMRb9bnHzmtz6hFhexq9YsYbtYdeOVUwh5%2BQ%40mail.gmail.com On 9/21/22 20:57, Thomas, Richard wrote: Thanks very much - 7-zip (from

Re: Creating constraint dynamically

2022-08-22 Thread JITEN KUMAR SHAH
On 8/22/22 13:09, Wim Bertels wrote: sivapostg...@yahoo.com schreef op ma 22-08-2022 om 07:29 [+]: ALTER TABLE public.tx_barcode_stock ADD CONSTRAINT "tx_barcode_stock_CK1" CHECK ( (branchcode = '1'::bpchar  and barcodeitem = 'Y'::bpchar and closingstock >= 0::numeric)  Or (branchcode = '

Re: Sub:column "" is of type bigint but expression is of type character varying

2022-08-17 Thread JITEN KUMAR SHAH
1. Please check you tickets_archive.ticket_purchase_no data type. 2. check if you are using correct schema. On 8/17/22 14:23, Rama Krishnan wrote: Hi All, I am having table name called tickets \d tickets             Column            |     Type             | Collation | Nullable | Default