Postgres Pro
Downloads
Home   >   mailing lists

psql & unix env variables - Mailing list pgsql-general

From Little, Douglas
Subject psql & unix env variables
Date
Msg-id 8585BA53443004458E0BAA6134C5A7FBB019562E@EGEXCMB01.oww.root.lcl
Whole thread Raw
Responses Re: psql & unix env variables  (Alan Hodgson <ahodgson@simkin.ca>)
Re: psql & unix env variables  (Ryan Kelly <rpkelly22@gmail.com>)
List pgsql-general
Tree view

Is there a method for having unix env variables incorporated into a psql sql statement?

Ie

Export var=’dev’

Psql =c ‘select count(*) from $var.customer;’

 

 

 

Doug Little

 

Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

 Description: cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 

Attachment

pgsql-general by date:

Previous
From: Aleksey Tsalolikhin
Date:
Subject: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL)
Next
From: Alan Hodgson
Date:
Subject: Re: psql & unix env variables