Posted by Toby A Inkster on 01/24/08 15:28

Dan99 wrote:

> Would it be enough to do something like SELECT * INTO table2 FROM table
> WITH OIDS

I've not tried that, but I imagine it will work. Relying on OIDs isn't a
great idea though, because:

a) they're a non-standard feature of PostgreSQL, so if you need
to move to a different database, you won't be able to use
them; and

b) PostgreSQL seems to be phasing them out, so if you *don't* move
to a different database, you may not be able to use them in the
future.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.17.14-mm-desktop-9mdvsmp, up 25 days, 2:38.]

CSS to HTML Compiler
http://tobyinkster.co.uk/blog/2008/01/22/css-compile/

• Next in forum: Re: Files in folder
• Prev in forum: Re: How to make URL cloaking
• Thread view: Re: No phpPgAdmin delete or edit links when browsing

[Reply to this message]