Posted by Dan99 on 01/24/08 21:18

On Jan 24, 10:28 am, Toby A Inkster <usenet200...@tobyinkster.co.uk>
wrote:
> 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/

I know this is starting to get way off of php, but you sound like you
know what you are talking about so I hope you dont mind helping me out
a bit more. Changing the config file worked good for creating new
tables with the oids, but I want to replicate all the existing tables
so that they have oids. I ran the following query on a test table
that does not have OIDs after changing the config:
SELECT * INTO table2 FROM table
This works well except for the fact that it doesnt copy anything but
the data. For example any indexes, constraints, or triggers do not
copy to the new table? How would I go about making an exact duplicate
of a table?

Thanks again,
Daniel

[Back to original message]