Re: [SQL] Exclude fields from SELECT command

Hello >> >> > > Workaround is create a view on that table excluding those 5 fields and then > select * from that view . > I know better solution. Use only thin tables. Wide tables are devil. :) regards Pavel Stehule > > With regards > Ashish Karalkar > > > > -- > Sent via pgsql-sql mailing lis

Re: [SQL] Exclude fields from SELECT command

Pavel Stehule wrote: 2009/3/16 Charles Tam : Hi Everybody I’ve a table with 35 fields and would like to perform a SELECT command without specifying every single field. As such, I’ve use the SELECT * command. Is there an approach to exclude 5 fields from being returned? hello n

Re: [SQL] Exclude fields from SELECT command

2009/3/16 Charles Tam : > Hi Everybody > > > > I’ve a table with 35 fields and would like to perform a SELECT command > without specifying every single field. > > As such, I’ve use the SELECT * command.  Is there an approach to exclude 5 > fields from being returned? > > > hello no, there are no

[SQL] Exclude fields from SELECT command

Hi Everybody I've a table with 35 fields and would like to perform a SELECT command without specifying every single field. As such, I've use the SELECT * command. Is there an approach to exclude 5 fields from being returned? Thanks for your time. Kind Regards Charles

[SQL] RE: [SQL] RE : [SQL] Convert text from U TF8 to ASCII

Sebastien, I know by looking at the data using PgAdmin. Met vriendelijke groet, Paul Dam Informatieanalist Amyyon Bijsterhuizen 11.58 6546 AS Nijmegen 050 - 311 5686 www.amyyon.nl Van: pgsql-sql-ow...@postgresql

Re: [SQL] Oracle to PostgreSQL

On Mon, Mar 16, 2009 at 12:35 AM, Greenhorn wrote: > Hi, > > I have almost 1300 files from Oracle (no access to oracle server).  I > have to create the tables and data as follows. (...) snip (...) > Any recommendation is greatly appreciated :) Try here: http://wiki.postgresql.org/wiki/Converting