On Feb 16, 2008 5:29 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote: > Ubence Quevedo wrote: > > What would the command be to have a query result be put into a > > location/space sensitive file [position 1 through 5 would be one thing > > where position 6 through 10 would be the next field, 11 through 16 > > another, etc]? Is this even possible with Postgres? > > Not possible --- many data types are of variable length. I think the OP was just looking at processing fixed with records into pgsql. If that's the case you can make a load table with one text field and select into from it with something like substring(field,1,5) etc... ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
