Search Postgresql Archives

Re: Query output into a space delimited/location sensitive file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Feb 16, 2008 7:19 PM, Ubence Quevedo <r0d3nt@xxxxxxxxxxx> wrote:
> Scott, you are exactly right.  I am looking to take various data in
> multiple tables and create an output file delimited into specific
> sections.  I'll look more into the proper usage of select into as well
> as the substring/field example you have given below.

Then you'll be wanting lpad or rpad to make the fixed widths.  It's
pretty straight ahead.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux