|
1) Are there free scripts for CREATE TYPE (native type), more advanced, <date> or <datetime> sorts of types out there, online, free for commercial use? With function support, too? Can someone reply with a link or a suggestion?
2) How may I get PostgreSQL to output the create table statement(s) for one or more tables inside one database, without issuing instructions via the command line, but only inside a database login, as a query or pl/sql? If not possible, what can you do
at the command line, outside
of PostgreSQL?
3) I know that I can use COPY to import or export one database table between it and a *.csv file. Can I use it to do this with multiple TABLES and *.csv files specified in one COPY COMMAND, or not?
4) In the absence of OS command line instructions, is there an internal PostgreSQL way, via COPY or another function for example, to backup an entire database, with all it's create table statements and all insert statements, and any other associated objects
as well, in one hit?
Or is this ill-advised?
5) When setting up communication to remote databases on remote machines, I need to use the OPTIONS() function. It seems to require as its first function parameter, the schema of the table (the second parameter) that it wants to access. Can I supply a null
schema, and still be able to reference the remote table, or must I also make use of IMPORT FOREIGN SCHEMA?
6) How may I access, via a query, the log for the details of a normal table, or similar?
|
