DROP FOREIGN DATA WRAPPER(7) SQL Commands DROP FOREIGN DATA WRAPPER(7)NAME
DROP FOREIGN DATA WRAPPER - remove a foreign-data wrapper
SYNOPSIS
DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE | RESTRICT ]
DESCRIPTION
DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. To execute this command, the current user must be the owner of the for-
eign-data wrapper.
PARAMETERS
IF EXISTS
Do not throw an error if the foreign-data wrapper does not exist. A notice is issued in this case.
name The name of an existing foreign-data wrapper.
CASCADE
Automatically drop objects that depend on the foreign-data wrapper (such as servers).
RESTRICT
Refuse to drop the foreign-data wrappers if any objects depend on it. This is the default.
EXAMPLES
Drop the foreign-data wrapper dbi:
DROP FOREIGN DATA WRAPPER dbi;
COMPATIBILITY
DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension.
SEE ALSO
CREATE FOREIGN DATA WRAPPER [create_foreign_data_wrapper(7)], ALTER FOREIGN DATA WRAPPER [alter_foreign_data_wrapper(7)]
SQL - Language Statements 2010-05-14 DROP FOREIGN DATA WRAPPER(7)
Check Out this Related Man Page
DROP FOREIGN TABLE(7) PostgreSQL 9.2.7 Documentation DROP FOREIGN TABLE(7)NAME
DROP_FOREIGN_TABLE - remove a foreign table
SYNOPSIS
DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP FOREIGN TABLE removes a foreign table. Only the owner of a foreign table can remove it.
PARAMETERS
IF EXISTS
Do not throw an error if the foreign table does not exist. A notice is issued in this case.
name
The name (optionally schema-qualified) of the foreign table to drop.
CASCADE
Automatically drop objects that depend on the foreign table (such as views).
RESTRICT
Refuse to drop the foreign table if any objects depend on it. This is the default.
EXAMPLES
To destroy two foreign tables, films and distributors:
DROP FOREIGN TABLE films, distributors;
COMPATIBILITY
This command conforms to the ISO/IEC 9075-9 (SQL/MED), except that the standard only allows one foreign table to be dropped per command,
and apart from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER FOREIGN TABLE (ALTER_FOREIGN_TABLE(7)), CREATE FOREIGN TABLE (CREATE_FOREIGN_TABLE(7))
PostgreSQL 9.2.7 2014-02-17 DROP FOREIGN TABLE(7)
FROM WINDOWS , WHILE GETTING DATA FROM HP-UNIX SERVER USING FTP, I AM ABLE TO GET DATA ONLY LESS THAN 4GB FILE, PLZ HELP ME HOW TO GET MORE MORE THAN 4GB FILE. (4 Replies)
Hi all,
i did typed the following code in vi and executed it.
#!/bin/sh
//notice the blank line here.
DATA=test
echo "$DATA"
There was no problem.
I then deleted the file using the rm command. I used ultraedit typed in the same file. , FTP it in and i got the following output
:... (2 Replies)
#!/usr/bin/perl
open (DATA, file.txt);
@array = <DATA>;
close (DATA);
open (DATA, ">$file.txt");
for (@array) {
s/text/replace text/;
push(@contents,$_);
}
seek(DATA, 0, 0);
print DATA (@contents);
close(DATA);
could someone please explain how this works. i've been... (3 Replies)
I have written a shell script which looks like below:
grep -v ',0,' ./DATA/abc.001 > ./DATA/abc.mid
egrep $GREPSEARCH ./DATA/ebc.mid > ./DATA/abc.cut
the variable GREPSEARCH has values like the below:
... (3 Replies)
I have a flat file and have foreign characters in three fields.
Can somebody tell me how to get rid of these special characters?
It's very urgent because without this my process is failing.
Thanks in advance.
Angielina (2 Replies)
Hello all, I need help with excluding the rows in which the data in the first column occur only once. For example;
DATA-1 8374 XX YY
DATA-1 9838 AB DD
DATA-1 8377 CC XY
DATA-2 8737 AB DD
DATA-3 7626 DC DD
DATA-3 8722 AB RE... (2 Replies)
I have a following containing DATA in the following format:
DATA....------
---------------
--------------
DATA.....------
--------------------
------------------
DATA....------
---------------
--------------
I want to extract the selective DATA in between identifiers and ... (4 Replies)
Hi ,
I have one file which has many headers.
Say suppose
HEDAER
..data DATA DATA
..data
..data
HEADER
..data
..data
DATA
.data
HEADER.
..data
..data
If there are 3 HEADERS in source file then I need to split the source file into 3 separate file.... (2 Replies)
Hi
experts
problem:
i have a directory "DATA" with lots of subdirectories named as date with hudge data containning files.
Directory = "DATA"
subdirectory = "20090611" & "20090612" ......
20090611 = thousands of files
i wanna apply find command to find all files in... (3 Replies)
DATA
---------------
0
Please tell me, if the file contains 0 after --. then assign the value to variable $var=false,
DATA
---------------
1
then $var=true, (2 Replies)
Hi again:
I have a log file wihch has always this format:
DATA line 1
DATA line 2
^^^^^
| Spaces or TABs
The first line always begins from the start, but the second begins with spaces or TABs,
Question:
How can I add the second line to the first one?
I mean this:
DATA... (6 Replies)
Input file (4 DATA record shown in this case):
DATA AA0110
ACCESSION AA0110
VERSION AA0110 GI:157412239
FEATURES Location/Qualifiers
length 1..1170
1..1700
/length="1170"
position ... (5 Replies)
I am looking to print the data in columns and after every 3 words it should be a new row.
cat example.out | awk 'END { for (i = 0; ++i < m;) print _;print _ }{ _ = _ x ? _ OFS $1 : $1}' m=1| grep -i INNER
I am looking to print in a new line after every 3 words.
... (2 Replies)
Hello everybody,
I have the following input file:
START ANALYSIS 1
DATA LINE
DATA LINE
DATA LINE
DATA LINE
Libray /home/me/myLibrary
Source library_name_AAAAA
DATA LINE
DATA LINE
DATA LINE
BEGIN SOURCE ANALYSIS
Function A
Function B
Function C
Function D (4 Replies)